Date Calculate

D

Dennis

I'd like to calculate the number "years" and "months" between a "start date" and "end date". I have a sheet that has the date a person entered our organization and the calculated =TODAY() date. I'd like to then have it converted to number of years and months in the organization.
 
F

Frank Kabel

Hi
have a look at
http://www.cpearson.com/excel/datedif.htm

--
Regards
Frank Kabel
Frankfurt, Germany
Dennis said:
I'd like to calculate the number "years" and "months" between a
Click to expand...
"start date" and "end date". I have a sheet that has the date a person
entered our organization and the calculated =TODAY() date. I'd like to
then have it converted to number of years and months in the
organization.
 
Top