Hints and tips home » Excel hints and tips » Difference between Two Dates

Difference between Two Dates

The DATEDIF function computes the difference between two dates. The DATEDIF function is as follows:

=DATEDIF (Date1,Date2,Interval)

Please note that Date1 must be less than (earlier) or equal to Date2

Please note that Interval must be one of the following codes: "d" (in days), "m" (in months), "y" (in years) expressed in quotes

Added by Orok on 19th October 2006

More Excel hints and tips, like:

• Quickly Adding New Worksheets
• Find cells that match a format
• Creating a range of monthly payments as text