Anniversary Dates

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
 
N

Norman Harker

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
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
E

Ed Pate

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
 
N

Norman Harker

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
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Top