DATEDIF Function (Functions in Excel)
FirstDate | SecondDate | Interval | Difference | |
1-Jan-60 | 10-May-70 | days | 3782 | =DATEDIF(C4,D4,"d") |
1-Jan-60 | 10-May-70 | months | 124 | =DATEDIF(C5,D5,"m") |
1-Jan-60 | 10-May-70 | years | 10 | =DATEDIF(C6,D6,"y") |
1-Jan-60 | 10-May-70 | yeardays | 130 | =DATEDIF(C7,D7,"yd") |
1-Jan-60 | 10-May-70 | yearmonths | 4 | =DATEDIF(C8,D8,"ym") |
1-Jan-60 | 10-May-70 | monthdays | 9 | =DATEDIF(C9,D9,"md") |
What Does It Do? | ||
This function calculates the difference between two dates. | ||
It can show the result in weeks, months or years. | ||
Syntax | ||
=DATEDIF(FirstDate,SecondDate,"Interval") | ||
FirstDate : This is the earliest of the two dates. | ||
SecondDate : This is the most recent of the two dates. | ||
"Interval" : This indicates what you want to calculate. | ||
These are the available intervals. | ||
"d" | Days between the two dates. | |
"m" | Months between the two dates. | |
"y" | Years between the two dates. | |
"yd" | Days between the dates, as if the dates were in the same year. | |
"ym" | Months between the dates, as if the dates were in the same year. | |
"md" | Days between the two dates, as if the dates were in the same month and year. | |
Formatting | ||
No special formatting is needed. | ||
Birth date : | 1-Jan-60 | |
Years lived : | 50 | =DATEDIF(C8,TODAY(),"y") |
and the months : | 4 | =DATEDIF(C8,TODAY(),"ym") |
and the days : | 9 | =DATEDIF(C8,TODAY(),"md") |
You can put this all together in one calculation, which creates a text version. | ||
Age is 50 Years, 4 Months and 9 Days | ||
="Age is "&DATEDIF(C8,TODAY(),"y")&" Years, "&DATEDIF(C8,TODAY(),"ym")&" Months and "&DATEDIF(C8,TODAY(),"md")&" Days" | ||
0 comments:
Post a Comment