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