tickler for date + 180 days

  • Thread starter Thread starter ram1000
  • Start date Start date
R

ram1000

I am new to this forum and a poor Excel user. I need to create a
tickler to inform me when a specific (180) number of days passes a date
in a cell. The starting date will be different in each consecutive
cell of a column but the 180 days is constant. I did a search and I
think I found the information I need, but I cannot decipher it to my
specific equation since I am a poor Excel user.

Thanks
 
Hi ram1000!

Try the following formula:

=IF(TODAY()-A8>=180,"Overdue","")

You must decide on whether it's >180 or >=180

Or you could use a conditional format on the cell to highlight it:

Format > Conditional Formatting
Formula Is:
Use the formula:
=(TODAY()-A1)>=180
Format select highlighting to taste
OK
OK
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Select your column of date cells.

Format>Conditional Formatting>Cell Value is:

Less Than =TODAY()-179

Select a Pattern Color from the Format Button then OK your way out.

When the date in a cell is 180 days old it will change color.

Gord Dibben Excel MVP
 
Back
Top