Figuring out dates using formulas in Microsoft Excel
Excel stores dates as serial numbers starting with 1 which represents January 1, 1900.
February 1, 1900 is stored as 32 and so on
Excel recognizes dates if you enter them as 05/25/2008 or 05-25-2008 or May 25, 2008
If the #VaLUE! error appears instead of a formula result, check the formatting of the dates entered.
In case you see a number after using a formula in a cell rather than a date, click on 'format' in the menu bar, select 'cells...' and then 'date' from the dialogue box
The training video shows how to calculate number of workdays between two dates in Excel
