CALCULATE YEARS AND MONTHS

Y

yvonneb

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
 
J

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
 
Top