Calculate the Number of Days Between Dates in Excel

If you need to know the number of days between a start and end date there is a function in Excel that can help you out.

The DATEDIF function will not only find the number of days, it can also be used to find the number of months or years as well.

One thing however, DATEDIF is undocumented - which means you won't find it listed with other functions in Excel. It does work though and it can simplify the task of finding the days, months, or years between dates.

To find out the details of using this function, read the article on Calculate the Number of Days Between Dates in Excel.

Related Articles

• Subtract Dates in Excel
• Adding the Date to a Spreadsheet
• Excel 2007 Date Options