EDATE & EOMONTH: Renewals, Due Dates & Fiscal Periods
This lesson is part of the course
In this lesson
You calculate renewal dates, end-of-next-month invoice due dates, calendar quarter ends and the fiscal year for Kestrel's eight maintenance contracts.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- How Excel Stores Dates: Serial Numbers, DATE, YEAR & TEXT Locked
- EDATE & EOMONTH: Renewals, Due Dates & Fiscal Periods Locked
- NETWORKDAYS & WORKDAY with Holidays and Custom Weekends Locked
- DATEDIF & YEARFRAC: Age, Tenure and Pro-Rata Amounts Locked
- WEEKDAY, WEEKNUM & ISOWEEKNUM: A Weekly Revenue Report Locked
- Time Math: Hours Worked, Overnight Shifts, MOD & ×24 Locked
- Weekly Timesheet: Regular Hours, Overtime & Pay Locked
- Project Schedule: WORKDAY Chains & a Gantt-Style Bar Chart Locked