Excel date and time functions: Theory and application

Deepen your understanding of Excel’s built-in date and time functions so you can more effectively perform complex calculations.

Event Details

Location and date:
Online On-Demand Event

Take your accounting performance to the next level by mastering the date and time functions of Excel. This online course explores how these functions work and provides tips and tricks 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 project schedules. This course includes extensive resources, an eBook and practical examples that are yours to keep.

View Table of Contents

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


3 CPD hour(s)
Pricing & registration

You will learn about:

  • how dates and times manifest in Excel
  • converting times back to whole numbers
  • using a variety of date manipulation functions
  • building a statutory holiday date calculator
  • date internationalization issues and how to get around them

Who should attend?

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

More Details:

Session Descriptions


Understanding dates in Excel
• What We Will Cover
• Understanding Dates in Excel
• Common Date Functions
• Today’s Date
• Date Extractions - Day and Month
• Date Extractions - Year and Week
• Date Conversion
• Date Creation
• What Have We Done

Temporal functions
• Santa’s Receivables
• Extracting Key Statistics
• Purchases and Interest - Part 1
• Purchases and Interest - Part 2
• Calculating Interest
• Cumulative A/R Balances
• What Have We Done

Understanding and manipulating time in Excel
• Understanding Time in Excel
• Manipulating Time in Excel
• Creating Time Sheets
• Pay Periods
• Calculating Regular Hours
• Calculating OT Hours - Part 1
• Calculating OT Hours - Part 2
• Calculating Banked Time
• Total Hours Payable
• What Have We Done

Workdays and holidays
• Calculating Workdays and Holidays
• Labour Hour Forecasting 02:13 Creating a Production Schedule
• Statutory Holidays - Part 1
• Statutory Holidays - Part 2
• Statutory Holidays - Part 3
• Creating a Labour Hour Forecast - Part 1
• Creating a Labour Hour Forecast - Part 2
• What Have We Done

• In Review
• Conclusion
• Final Quiz


You may also be interested in:


Please contact:

CPA Canada Professional Learning and Development Customer Service
Tel: 1-888-337-3242
Email: pld@cpacanada.ca


Jointly presented by CPA Canada and CPA Ontario, The ONE is the must-attend, multi-track event of the year, designed for all CPAs who want to be at the top of their game.

Our Firm Directory allows you to search for Canadian CPA firms using our interactive map as well as other criteria.

You’re in the eye of the storm amid a swirl of slips, forms and receipts. Chart your way through tax-time turbulence with these updates and resources.