dates and formats

J

Jenny dev

I am trying on one colum to have the dates 01/07/2008 (dd/mm/yy) right until
30/06/2008 but l just cannot get it to do this. What am l doing wrong. have
typed dates in 2 cells the hage highlighted both boexs until + appears and
drag down this stops at month 12. Please can some one assits me in this
beofre l go crazy
 
M

Max

Enter an unambiguous startdate in say, A1: 01-Jul-2008. Just drag A1 down as
far as required. It'll increment one day per row. Then only format the col in
the date format that you want to taste.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:16,000 Files:354 Subscribers:53
xdemechanik
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Color coding dates in excel 7
match one column with dates to several colums with dates, copy pas 4
Date and Number cell formats 4
Count Dates between Dates exclude Text 3
Sumproduct and dates 5
Working with dates and time 5
Date formatting problem on some PCs 2
How do I change dd/mm/yy to dd-month-yy? 6

Top