Date Sequence

[Daren]

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.

 

[Pete_UK]

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

 

[Mike H]

Hi,

Put a start date in (say) A1 then select A2 down as many cells as you need
then

Data|Validation
Select Date
Select 'Greater than' or possibly 'Greater than equal to'
enter =A1 in the start date box
OK

Dates must now be entered in ascending order.

Mike