Home / MS-Excel / Functions and Formula

Date and Time Formulas in Excel

Formulas that perform calculations between elapsed dates and times are quite common in spreadsheets.

In this tutorial give you a chance to build formulas that

  • Calculate the difference between starting and ending dates and times as well as
  • Use Excel Date and Time functions to perform a variety of tasks
  • including returning the current date and time in a spreadsheet
  • converting text entries to valid date and time numbers, and more.

In this tutorial:

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