Excel 365 Basics #4: Date & Time Formulas, Functions & Formatting: All The Basics You Need to Know

Download Excel File: https://people.highline.edu/mgirvin/AllClasses/218M365/Content/ExcelBasics04.xlsx Link to full Excel Basics Class: https://www.youtube.com/playlist?list=PLrRPvpgDmw0k7ocn_EnBaSJ6RwLDOZdfo 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