difference two date

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

Guest

Anyone pl help me. How calculate difference between two date in the
year,month & date. I want to difference year, month & date ( all are
calculate).

Ex.
a1 = {01/12/1950}
b1={01/11/1960}

result we want b1-a1 = 9 year 1 month 10 days. (These format)

Pl Help me.
 
=DATEDIF(A1,B1,"Y")&" years "&DATEDIF(A1,B1,"Ym")&" months
"&DATEDIF(A1,B1,"Md")&" days"

Regards,
KL
 

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 1
Excel Date Display? 8
Difference of two dates 3
calculating dates 4
Date format 5
Help with date difference 1
Populate year, month and quarter from entered date 2
Calculate difference in dates 11

Back
Top