Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to Highlight the date if it is within 3 months from now
I am working with a spreadsheet having to do with various training my staff
must have. Some of the certificates expire after a few years, and I wanted to enter a function so that a cell is highlighted when it is within 3 months from expiring, so that I will know to schedule a new training session. I tried using the Conditional Formatting option, but wasn't sure what formula to write. Help! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to Highlight the date if it is within 3 months from now
HR gal
=A1<TODAY()+90 Assuming future date is in A1 To enter into the range of cells A1:A23, select the range then FormatCFFormula is: =$A1<TODAY()+90 Note the $ sign to anchor the collumn reference but allow the row reference to increment from A1:A23 Gord Dibben Excel MVP On Fri, 9 Dec 2005 14:09:02 -0800, HR gal wrote: I am working with a spreadsheet having to do with various training my staff must have. Some of the certificates expire after a few years, and I wanted to enter a function so that a cell is highlighted when it is within 3 months from expiring, so that I will know to schedule a new training session. I tried using the Conditional Formatting option, but wasn't sure what formula to write. Help! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to Highlight the date if it is within 3 months from now
Your formula in conditional formatting could be (where D2 is cell with the
date): =IF(DATEDIF(TODAY()+1,D2,"m")<3,TRUE,FALSE) This method, as opposed to adding 90 days will highlight anything that is within 3 calendar months. If run today is Nov 25, it will highlight every date from Nov 26 to Feb 25. The 90 day method will highlight up to Feb 23. "HR gal" wrote: I am working with a spreadsheet having to do with various training my staff must have. Some of the certificates expire after a few years, and I wanted to enter a function so that a cell is highlighted when it is within 3 months from expiring, so that I will know to schedule a new training session. I tried using the Conditional Formatting option, but wasn't sure what formula to write. Help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Another Date issue. | Excel Worksheet Functions | |||
Working days left in the month compared to previous months | Excel Worksheet Functions | |||
Date difference | Excel Worksheet Functions | |||
need an overdue date to highlight | Excel Discussion (Misc queries) | |||
Using formulas to determine date in one cell based on date in anot | Excel Worksheet Functions |