| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Comparing dates
Hi
I have a date in A5 and I need to write a formula in an adjacent column that checks the date and if the date is less than 3 months old to display it in another colour, if it is more than 3 months old to do nothing. I am not sure which date function to use. Can anyone help? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 2 digit year in dates return 19xx not 20xx | Excel Discussion (Misc queries) | |||
| return array result in cell based on comparing dates | Excel Worksheet Functions | |||
| Comparing Dates using Greater Than and Less than | Excel Discussion (Misc queries) | |||
| Comparing dates in an IF function | Excel Worksheet Functions | |||
| Formating Dates for production schedule | Excel Discussion (Misc queries) | |||
Threaded Mode
