MS-Excel / Functions and Formula

Working with Simple Date Functions

Excel contains a number of straightforward Date functions that help you work with dates in your spreadsheets. These functions run the gamut from those that return the current date to those that convert text to date serial numbers (so you can use them in formulas that compute the number of days that have elapsed).

Following these sections:

  • TODAY, NOW, DATE, and DATEVALUE Date Functions
  • Working with Excel's More Date Functions
  • WEEKDAY, WEEKNUM, and YEARFRAC Date Functions
  • Working with the Time Functions
  • Building Formulas with Common Time Functions
[Previous] [Contents] [Next]

In this tutorial:

  1. Date and Time Formulas in Excel
  2. Constructing Date and Time Formulas
  3. Building Formulas that Calculate Dates and Times
  4. Working with Simple Date Functions
  5. TODAY, NOW, DATE, and DATEVALUE Date Functions
  6. Working with Excel's More Date Functions
  7. WEEKDAY, WEEKNUM, and YEARFRAC Date Functions
  8. Working with the Time Functions
  9. Building Formulas with Common Time Functions