Shopping and Product Reviews

MS Excel Tips - Subtracting Dates In Excel

Quite often in Excel you will want to subtract one date from another.  This could be to check length of service of an employee, how long a customer has taken to pay a bill or the length of a project.

I find the most versatile  function to use for this is DATEDIF.  This actually stands for DATE DIFFERENCE and can be used in Excel 97 onwards. 

It is a somewhat undocumented function and is not listed in the formula tab in Excel 2007.  This formula must be manually typed into a cell on your work book rather than in a dialog box that can be used in other Excel functions.

The syntax for