Excel date and time functions

Deepen your understanding of Excel’s date and time functions so you can perform complex calculations using Microsoft 365.

Event Details

Location and date:
Online On-Demand Event

Take your performance to the next level by mastering the date and time functions of Excel. This online course explores how these functions work and provides instructions for using them in different contexts.

You will gain the knowledge and skills to use these Excel functions more effectively when managing payroll, holiday hours and large production schedules.

This online, video-led course is performed using Excel for Microsoft 365 and includes an eBook and practical examples that are yours to keep.

Note: This course can be taken individually or as part of the Comprehensive Excel Certificate Program.

Additional options and pricing may be available. See pricing and registration for more details.

Member $229, Non Member $275

3 CPD hour(s)
Pricing & registration

You will learn about:

  • how dates and times manifest in Excel
  • a variety of date and time manipulation functions
  • date internationalization issues and how to get around them
  • calculating cumulative A/R balances with date functions
  • creating a production schedule using date functions

Who should attend?

  • advanced Excel users
  • IT professionals
  • business intelligence educators
  • consultants
  • financial analysts

More Details:


You may also be interested in:

Learn how to use essential functions in Excel for Microsoft 365 that will help you evaluate financial data and make better business decisions.

Learn how to create tabular data sets in Excel so you can better organize and analyze financial information using Microsoft 365.


Please contact:

Member Development and Support
Tel: 1-800-268-3793
Email: [email protected]