Date Calculate
 

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.

Date Calculate
 

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

--
Regards
Frank Kabel
Frankfurt, Germany
"Dennis" schrieb im Newsbeitrag
...
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.