Excel Yourself/Excel Date and Time Calculations

Date and Time Formulas and Functions

Discover the functions that handle different types of calculations. 

See how to avoid some of the frustrations that dates and times can cause. Topics covered include:
  • adding months to a date
  • formulas for the first and last day of the month
  • using today’s date in a formula
  • handling days of the week calculations
  • automating dates in headings
  • how to avoid the traps in time calculations
  • remove times from dates
  • generating random dates (for testing)

As always there will be a few other tips and tricks shared during the session.

Level: Intermediate
Duration: 1 hour
Price: Free

  • Free

Excel Date and Time Calculations

Learn the tricks to perform calculation with dates and time.

Contents

Excel Date and Time Calculations

Date and Time Formulas and Functions

Course Materials

The pdf manual plus the Excel file for the session. includes the completed file from the session as well.
Excel Date and Time Calculations 2020.pdf
Excel Dates and Times 2020.xlsx
Excel Dates and Times 2020 completed.xlsx

Webinar Recording

The recording of the live webinar.
Date and Time Calculations video