PDA

View Full Version : ANNIVERSARY DATE



wilg
01-25-2011, 04:31 PM
I have an employee who is hired say Oct 21, 1994. Today is Jan 25th 2011.

How can I use a cell formula that tells me how many days till next Oct 21 which is his anniversary date?

When I do his hire date - now() it gives me how many days since he was hired. Like 5941 days... I only want till next Oct 21st.

Thoughts?

p45cal
01-25-2011, 05:42 PM
in haste (there must be a shorter way) (G17 contains hire date):
=DATE(YEAR(TODAY())+IF(DATE(YEAR(TODAY()),MONTH(G17),DAY(G17))-TODAY()>0,0,1),MONTH(G17),DAY(G17))-TODAY()

wilg
01-25-2011, 05:55 PM
Very nice.....worked well. Or so I can see. Though I didnt actually count to verify 269 days from now is Oct 21st but it seems like the right number to me. Thanks so much.

p45cal
01-25-2011, 06:00 PM
well test with anniversary dates one or two days either side of the current month/date - say 25-jan-1994 and 27-Jan 1994