View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default Calculate Number of years

If you only want the calendar days just use

=TODAY()-start

e.g.

a1 holds the start date 08/12/1995

=TODAY()-A1


format as general will return the days, if you want years look here

http://www.cpearson.com/excel/datedif.aspx

will look like

=DATEDIF(A1,TODAY(),"y")



--


Regards,


Peo Sjoblom


"Needs Help" wrote in message
...
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!