calculate date differences in years and months

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I calculate differences in dates in months and years? I can do days,
months, and years, but not a combination.
 
Hi Joyce

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

with your starting date in A1 and your ending date in B1

Cheers
JulieD
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Vba to change displayed year automatically. 14
Calculation using a date 6
Add/Sum up months, years, dates 4
Calculate month & year in between two dates 2
date function 10
calculate fractions using dates 6
Help required on Tabulating monthly expenses for the Current Month,Previous Month and Month previous 12
Excel - Calculate age from DOB in years, months days 7

Back
Top