| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If functions and dates
I have a list of dates in column A. These dates are when the next
safety check will (or should) take place. In some cases the safety checks have been missed and are overdue. What i would like is some kind of function in column B to state whether the safety check date is overdue, less than 3 months away, less than 6 months away or more than 6 months away. I have tried in vain to do this with an IF function. Can someone help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If functions for dates | Excel Worksheet Functions | |||
| Need help with HLOOKUP and MATCH functions | Excel Worksheet Functions | |||
| Date functions for dates pre-1900 | Excel Discussion (Misc queries) | |||
| Using Dates in Count functions | Excel Worksheet Functions | |||
| worksheet functions with dates | Excel Worksheet Functions | |||
Threaded Mode
