Excel Yourself/Date and Time Calculations 2026

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

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

    Level: Intermediate
    Duration: 1 hour
    Price: Free

  • Free

Date and Time Calculations 2026

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 Dates and Times 2026.xlsx
Excel Date and Time Calculations 2026.pdf
Excel Dates and Times 2026 completed.xlsx

Webinar Recording

The recording of the live webinar.
Dates and Times Calculations - recorded Sep 2026