WD.DATEDIF

Description

Syntax

start_date
: The starting date for the count. Workday recommends using a cell reference to specify the date instead of entering the date as text, to ensure reliable results.
end_date
: The ending date for the count. Workday recommends using a cell reference to specify the date instead of entering the date as text, to ensure reliable results.
period
: The number of whole periods between
start_date
and
end_date
. If the period is a grouping of values, such as
YMD
, the function calculates all the whole periods as segments; you use the
unit
argument to specify which number (segment) to return. Example: If the
start_date
is January 1, 2010, and the
end_date
is February 3, 2020, then the function calculates that Year=10, Month=1 and Day=2. If the unit=Month, the function returns 1.
Year (Y)
Month (M)
Week (W)
Day (D)
Hour (H)
Minute (M)
Second (Sec or S)
Milli (Mil or MS)
YearMonthWeekDayTime (YMWDT): Years, months, weeks, days, hours, minutes, seconds, and milliseconds.
YearMonthDayTime (YMDT): Years, months, days, hours, minutes, seconds, and milliseconds
YearMonthDay (YMD): Years, months, and days
YearWeekDayTime (YMDT): Years, weeks, days, hours, minutes, seconds, and milliseconds
YearWeekDay (YWD): Years, weeks, and days
YearDayTime (YDT): Years, days, hours, minutes, seconds, and milliseconds
YearDay (YD): Years and days
DayTime (DT): Days, hours, minutes, seconds, and milliseconds
Time (T): Hours, minutes, seconds, and milliseconds
unit
: The number to return. If the
period
is a single value, such as Day, the
unit
must match the
period
. If the
period
is a grouped value, such as YMD, the
unit
must match one of the segments in the
period
.
Year (Y)
Month (M)
Week (W)
Day (D)
Hour (H)
Minute (Min)
Second (S or Sec)
Milli (or MS or Mil)

Example