DATEDIF & YEARFRAC: Age, Tenure and Pro-Rata Amounts
This lesson is part of the course
In this lesson
You calculate each employee's age and tenure on the report date, write the tenure as "years and months", turn it into decimal years with YEARFRAC and pay a pro-rata bonus.
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