Download Excel File: https://people.highline.edu/mgirvin/AllClasses/218M365/Content/ExcelBasics04.xlsx
Read (download right-click): pdf notes: https://people.highline.edu/mgirvin/AllClasses/218M365/Content/ExcelBasics04.pdf
In this video learn about
Topics:
1. (00:00) Introduction
2. (00:38) How Dates work in Excel (Date Serial Numbers, Date Number Format and Date Formulas)
3. (07:57) Formulas to calculate number of days between two dates, for invoices, loans and projects
4. (10:00) Formulas to count workdays with NETWORKDAYS.INTL function
5. (12:00) Series dialog box to create list of dates
6. (14:40) 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. (16:22) Subtract days from dates to get past date. Examples such as calculating the date that a project was started.
8. (18:09) Move date forward or backwards by a specified number of months with EDATE and EOMONTH functions. Examples with invoices.
9. (21:00) 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. (23:02) How Times work in Excel (Time Serial Numbers, Time Number Format and Time Formulas)
11. (31:18) Time formulas for payroll
12. (35:40) 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. (41:03) Summary
14. (42:06) Closing