Calculate Number of years
If you have a hire date in A1, then this formula in B1 will give you
the number of years:
=(TODAY()-A1)/365.25
Format the cell as General, or as Number with 2 dp.
To get 75 days after a hire date which is in A2, use this:
=A2+75
Format this cell as a date.
Hope this helps.
Pete
On Dec 7, 3:02 pm, Needs Help
wrote:
I am trying to calcualte number of years an employee has been with the
company from today's date. I can't seem to find a formula that will help me
with that.
Also, I need a formula that will calculate 75 workdays from date of hire.
Thanks!
|