Free Microsoft Excel Training Videos

Using date functions in Excel

Using date functions in Excel you can manage projects. Excel can calculate the working days needed to complete a project using straightforward formulas.
How does Excel recognize dates and the relevant functions and formulas?
  • 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 Networkdays function calculates the weekdays between two dates.
  • The Workday  formula can help the user find the delivery date of a project.
  • The training video shows how to calculate number of workdays between two dates in Excel

How to use dates and time in Excel

Using dates and time in Excel



Using date functions in Excel