Completed
1. Introduction
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Microsoft 365 Excel - Date and Time Formulas, Functions and Formatting - Part 4
Automatically move to the next video in the Classroom when playback concludes
- 1 1. Introduction
- 2 2. How Dates work in Excel Date Serial Numbers, Date Number Format and Date Formulas
- 3 3. Formulas to calculate number of days between two dates, for invoices, loans and projects
- 4 4. Formulas to count workdays with NETWORKDAYS.INTL function
- 5 5. Series dialog box to create list of dates
- 6 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 7. Subtract days from dates to get past date. Examples such as calculating the date that a project was started.
- 8 8. Move date forward or backwards by a specified number of months with EDATE and EOMONTH functions. Examples with invoices.
- 9 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 10. How Times work in Excel Time Serial Numbers, Time Number Format and Time Formulas
- 11 11. Time formulas for payroll
- 12 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 13. Summary
- 14 14. Closing
