## DATEDIF In Excel 2010

The DATEDIF function in Microsoft Excel calculates the difference, or interval, between two dates. This difference can be expressed in a variety of ways. The function takes the form

=DATEDIF(Date1, Date2, Interval)

where Date1 and Date2 are the two dates and Interval defines how the date difference should be returned. Interval must be enclosed in quotes like this:

=DATEDIF(Date1, Date2, “d”)

These are the errors that DATEDIF may return if you get something wrong:

• #NUM error if Date1 is later than Date2
• #VALUE error if either Date1 or Date2 are invalid dates
• #NUM error if the Interval specified is not one of the allowed values

The Interval must be one of the following values:

Interval Use
m Months: the number of whole calendar months between the two dates
d Days: the number of days between the dates
y Years: the number of whole calendar years between the dates
ym Months In Same Year: the number of months between the two dates if they were in the same year
yd Days In Same Year: the number of days between the two dates if they were in the same year
md Days In Same Month And Year: the number of days between the two dates if they were in the same month and year

## DATEDIF Examples

Try and predict what the result of the following examples will be:

DATEDIF Result
=DATEDIF(01/01/2010, 01/06/2010, “d”) 151
=DATEDIF(01/01/2010, 15/01/2010, “d”) 14
=DATEDIF(01/01/2010, 01/06/2010, “m”) 5
=DATEDIF(01/01/2010, 15/01/2010, “m”) 0
=DATEDIF(01/01/2009, 01/06/2010, “m”) 17
=DATEDIF(18/08/2008, 01/03/2010, “y”) 2
=DATEDIF(01/01/2010, 31/12/2010, “y”) 0
=DATEDIF(01/01/2008, 01/06/2010, “ym”) 5
=DATEDIF(23/04/2003, 31/05/2005, “yd”) 38
=DATEDIF(17/02/1974, 28/01/1998, “md”) 11