Thread: Date Sequence
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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.