D
Danny Boy
Here is a formula that I have which works to produce a "Happy Anniversary"
flag:
=IF(AND(DAY(E4)=DAY(TODAY()),MONTH(E4)=MONTH(TODAY())),"Happy Anniversary","")
The flag is triggered based upon the date entered into cell E4 (date of
original member registration). At the moment, the flag triggers annually, on
the members anniverary date, however it also triggers if I type in "todays"
date.
I'd like help in altering the formula somewhat so that the "Happy
Anniversary" flag does NOT appear when the actual date typed into cell E4 is
today (e.g. Jan 27, 2009), but only triggers annually on the actual date of
anniversary (e.g. Jan 27, 2010, Jan 27, 2011, etc).
In addition (if possible), I'd love for the flag to change with the years
(e.g Happy 1st Anniversary, Happy 2nd Anniversary, etc) if possible.
Thank you very much for any help given!
Best,
Dan
flag:
=IF(AND(DAY(E4)=DAY(TODAY()),MONTH(E4)=MONTH(TODAY())),"Happy Anniversary","")
The flag is triggered based upon the date entered into cell E4 (date of
original member registration). At the moment, the flag triggers annually, on
the members anniverary date, however it also triggers if I type in "todays"
date.
I'd like help in altering the formula somewhat so that the "Happy
Anniversary" flag does NOT appear when the actual date typed into cell E4 is
today (e.g. Jan 27, 2009), but only triggers annually on the actual date of
anniversary (e.g. Jan 27, 2010, Jan 27, 2011, etc).
In addition (if possible), I'd love for the flag to change with the years
(e.g Happy 1st Anniversary, Happy 2nd Anniversary, etc) if possible.
Thank you very much for any help given!
Best,
Dan