Anniversary date

  • Thread starter Thread starter Pete
  • Start date Start date
P

Pete

Ok I am stumped on this one. Lets say I have an employees hire date in sell
A1 "10/14/1994". Now in another cell (can be anywhere) B2 I would like
something like True or False if the the employees anniversary is with 15
days of the current date.

Any ideas?

I have been playing with this datedif but can not get the results I am
looking for.
 
Hi Pete!

Try:

=IF(AND(MONTH(TODAY())=MONTH(A3),DAY(TODAY())=DAY(A3)),"Anniversary",I
F(TODAY()>=DATE(YEAR(A3)+DATEDIF(A3,TODAY(),"y")+1,MONTH(A3),DAY(A3))-
15,TRUE,FALSE))

Gives you a 15 day warning of the anniversary plus returns
"Anniversary" on the day itself. Tough if they joined on 29-Feb.

--
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.
 
Note that as a bit of an anomaly, if you're using the 1904 Date
system and it just happens to be January 1st, a blank in A3 will
return "Anniversary".
 
Hi JE!

Interesting!

--
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