Date and Time Functions

This is the agenda for Table of Contents
Table of Contents


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


Chartered Professional Accountants of Canada (CPA Canada) annually offers its views on priorities for the federal budget. Review past submissions of pre-budget briefs and consultations, and post-budget release opinions and commentary.

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

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.