Date Sequence
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
"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.
|