CALCULATE YEARS AND MONTHS

[Guest]

Dear All
I have a spreadsheet with employee start dates. I want to calculate how
long each employee has been with us, in years and months using:
Col A = start date
Col B = today's date
Col C = length of service.
I can do it using fractions, but would prefer if it calculated the actual
years/months ie 4.7 = 4 yrs, 7 mths.
Many thanks

 

[Frank Kabel]

Hi
use DATEDIF for this. See:
http://www.cpearson.com/excel/datedif.htm

 

[John Mansfield]

Hi,

Assuming your start date is in cell B1 and your end date
is in cell A1 enter the following formula:

=DATEDIF(B1,A1,"y") & " years, " & DATEDIF(B1,A1,"ym") & "
months"

John Mansfield
pdbook.com