Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Happy Anniversary Flag?
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Happy Birthday Formula Flag Needed | Excel Worksheet Functions | |||
next anniversary date | Excel Discussion (Misc queries) | |||
Please Reply to this Thanks to all - Merry Xmas!, Happy Chanukah!, Happy ID | Excel Discussion (Misc queries) | |||
anniversary dates | Excel Discussion (Misc queries) | |||
Calculating Anniversary | Excel Discussion (Misc queries) |