View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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!