Anniversary Dates

  • Thread starter Thread starter Ed Pate
  • Start date Start date
E

Ed Pate

I have a date in cell A3 which is =today(). I have dates listed in cell
B5:B55 which are the anniversary dates employees were hired whic
obviously are different dates. What I need is for cells C5:C55 t
display NO until the employees anniversary date comes up, then displa
YES. I would like it to do this each time the employees anniversar
comes around! Any suggestion or a better way to accomplish this woul
be greatly appreciated.
Thank
 
Hi Ed!

C5:
=IF(AND(MONTH(B5)=MONTH($A$3),DAY(B5)=DAY($A$3)),"YES","NO")
Copy down

--
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.
 
Hi Norman,

Your formula worked like a charm. I greatly appreciated your help. N
matter what I tried I could'nt get it right to save my life however
thanks to you I may just take the rest of the day off. Again Thanks
 
Hi Ed!

Re: "thanks to you I may just take the rest of the day off"

But tell the boss that it took all weekend!

--
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.
 
Back
Top