Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I set my system date as day-- month--year sequence? | Excel Discussion (Misc queries) | |||
Macro help inserting records by date sequence. | Excel Discussion (Misc queries) | |||
sequence number based on date | Excel Worksheet Functions | |||
Set tab sequence help | Excel Discussion (Misc queries) | |||
the first in a sequence | Excel Discussion (Misc queries) |