22. Tenure, Deadlines, Weekdays

• DATEDIF(start, end, "y") gives complete years between two dates ("m" for months, "d" for days). DATEDIF works but is not listed in Excel's function suggestions;
• EDATE(date, n) is the date n months later (January 31 + 1 month = February 28);
• EOMONTH(date, 0) is the last day of the month;
• WEEKDAY(date, 2) gives the day of the week as a number, where 1 is Monday and 7 is Sunday.

Instead of TODAY(), this lesson uses a fixed report date in G1, so the answers don't change from day to day.