Conditional format for future date

  • Thread starter Thread starter Kerry
  • Start date Start date
K

Kerry

Hi All
I have entered todays date into a cell and I would like that cell to change
colour 2 months in the future. I know I have used =TODAY()-60 for dates equal
to or greater than than 2 months past. What would the formula be for a future
date?

Thankyou, Kerry
 
If you were happy with TODAY()-60 as a rough approximation for 2 months in
the past, then perhaps you might think about what sign you could put instead
of the minus sign for 2 months in the future?
If you really wanted 2 months before today, you wouldn't have used
TODAY()-60, but instead would have had
DATE(YEAR(TODAY()),MONTH(TODAY())-2,DAY(TODAY()))
and for 2 days in the future you would have
DATE(YEAR(TODAY()),MONTH(TODAY())+2,DAY(TODAY()))
Note that you may also want to think about what date you regard as being 2
months after 31st December, or 2 months before 30th April, for example.
 
Thanks David,

I think I answered my own question already in that the date in the cell will
be 60 days in the past in 2 months time so the formula =TODAY()-60 is
probably a valid formula. I will experiment with the formula you have
provided as I am not sure how it works. Much appreciate your help.

Kerry
 
Back
Top