calculate date differences in years and months

J

Joyce

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

JulieD

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
 

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

Expanding Date Formula 0
Send meeting request for different dates (no repetition) to different people 0
Incone & Expenses Statement 0
HOW TO INPUT MONTHLY ACCUMULATED SALARY IN MS PROJECT? 0
Percentage of month passed formula 1
Date / month / year 1
find out specific month and year 1
Carry over YTD balance to next worksheet 4

Top