Flaging Dates

P

Paul

I have a spread sheet that has training certificate dates. Some are pass
dates, others are expiry dates.
I need to be able to flag them up 2 months prior to their expiry dates.

Can anyone help?
Thanks
 
M

Marcelo

Hi Paul,

conditional format change to "the formula is" and use

=date(year($h$1),month($h$1)+2,day($h$1))=c2

assuming that you use in H1 =today()

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Paul" escreveu:
 
Top