Thread: Flaging Dates
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marcelo Marcelo is offline
external usenet poster
 
Posts: 1,047
Default 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