EDATE and EOMONTH practice exercises
Move a date by whole months, and find the last or first day of a month, for contract ends, renewals and payment terms.
- 1Contract end date with EDATEIn C2, use EDATE to find the date the number of months in B2 after the start date in A2.
- 2Last day of the month with EOMONTHPremiumIn B2, use EOMONTH to find the last day of the month of the invoice date in A2.
- 3First day of next monthPremiumA subscription starts on the first day of the month after it is signed. In B2, find that date from A2. Take the end of the signing month with EOMONTH and add one day.
- 4Days in the month with DAY and EOMONTHPremiumTo prorate the first month's rent you need the number of days in the move-in month. In B2, take the day number of the month's last day, DAY(EOMONTH(A2,0)).