| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
IF Statement with Date data
Hi
I run Win2k with Excel 2K I would like to have a formula that looks at a range of dates, then determines the "latest" date in that range. Then if that "latest" date is greater than 30 days from the "current" date, display a message "DUE". If your require anymore info please let me know. Thanks John |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| unable to change date format on imported data | Excel Discussion (Misc queries) | |||
| compare date to column data | Excel Worksheet Functions | |||
| macro to sort data in worksheet by specific date | Excel Discussion (Misc queries) | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| bringing data from one workbook to another using a date stamp func | Excel Worksheet Functions | |||
Threaded Mode
