Flaging Dates
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:
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
|