DatedIF Formula
This
function calculates the difference between two dates. It can
show the result in weeks, months or years.
|
|
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 :
|
51
|
=DATEDIF(C8,TODAY(),"y")
|
|
||
|
|
and the
months :
|
8
|
=DATEDIF(C8,TODAY(),"ym")
|
|
||
|
|
and the
days :
|
24
|
=DATEDIF(C8,TODAY(),"md")
|
|
||
|
|
|
|
|
|
|
|
|
|
You can
put this all together in one calculation, which creates a text version.
|
|||||
|
|
Age is 51 Years, 8 Months and 24 Days
|
|
|
|
|
|
|
|
="Age is
"&DATEDIF(C8,TODAY(),"y")&" Years,
"&DATEDIF(C8,TODAY(),"ym")&" Months and
"&DATEDIF(C8,TODAY(),"md")&" Days"
|
|||||