Microsoft 365 Excel - Date and Time Formulas, Functions and Formatting - Part 4

Overview

Learn essential Excel date and time functions in this 42-minute tutorial video that covers everything from basic date serial numbers to complex time calculations. Master formulas for calculating days between dates, counting workdays using NETWORKDAYS.INTL, creating date lists, and managing future/past dates with WORKDAY.INTL. Explore date manipulation with EDATE and EOMONTH functions for invoice management, extract date components using YEAR, MONTH, and DAY functions, and understand time serial numbers for payroll calculations. Discover advanced techniques for handling night shift payroll scenarios that cross midnight using Date-Time Serial Numbers and the MOD function. Downloadable practice files and PDF notes are provided to reinforce learning through hands-on examples with invoices, loans, and project management scenarios.

Syllabus

1. Introduction
2. How Dates work in Excel Date Serial Numbers, Date Number Format and Date Formulas
3. Formulas to calculate number of days between two dates, for invoices, loans and projects
4. Formulas to count workdays with NETWORKDAYS.INTL function
5. Series dialog box to create list of dates
6. Add days to date to get future date. Learn about WORKDAY.INTL to find future or past date based on workdays only. Examples such as calculating loan due dates..
7. Subtract days from dates to get past date. Examples such as calculating the date that a project was started.
8. Move date forward or backwards by a specified number of months with EDATE and EOMONTH functions. Examples with invoices.
9. Extract the year, month or day from a Serial Number date using the functions, YEAR, MONTH, DAY, and TEXT with custom number formatting. Examples for a date table.
10. How Times work in Excel Time Serial Numbers, Time Number Format and Time Formulas
11. Time formulas for payroll
12. Time formulas for night shift payroll: when employee works past midnight and into next day. Learn about Date-Time Serial Numbers and the MOD function.
13. Summary
14. Closing