-
ANNIVERSARY DATE
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?
-
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()
p45cal
Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
-
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.
-
well test with anniversary dates one or two days either side of the current month/date - say 25-jan-1994 and 27-Jan 1994
p45cal
Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules