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.
|