Completed
3. Formulas to calculate number of days between two dates, for invoices, loans and projects
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
