Home |
Search |
Today's Posts |
#1
|
|||
|
|||
difference two date
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. |
#2
|
|||
|
|||
=DATEDIF(A1,B1,"Y")&" years "&DATEDIF(A1,B1,"Ym")&" months
"&DATEDIF(A1,B1,"Md")&" days" Regards, KL "RKS" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
search for latest date | Excel Worksheet Functions | |||
Date difference | Excel Worksheet Functions | |||
Date difference taking into account weekends. | Excel Worksheet Functions | |||
Difference of date | New Users to Excel |