Thread: Date Sequence
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Date Sequence

Put your first dates in A1, B1, C1 etc. Then in A2 you can use this:

=A1+1

Format as a date, then copy down and across. If the dates in column B
are meant to be continuous from the last date in column A, then use
this in B1:

=Ax+1

where Ax is the last cell you use in column A (A65536 ?).

Hope this helps.

Pete

On Oct 1, 2:36*pm, Daren wrote:
I have four colums of dates that are supposed to occur in order, e.g. 4/1/08,
5/2/08, 6/2/08, and 7/2/08. *Is there a formula I can use to ensure those
dates occur in sequence. *

Thanks.