DATEDIF functionAdded by IBM on December 13, 2012 | Version 1 (Original)
|Returns the number of years, months, or days between two dates.
DATEDIF (start date
, end date
Computes the difference between start date
and end date
in the unit specified in format
, a code that you enter as text.
Table 1. Format codes for specifying unit returned
|MD||Days, ignoring months and years|
|YM||Months, ignoring years|
|YD||Days, ignoring years|
Parent topic: Date and time functions