About this exercise
A 60-row dataset on one sheet, one answer cell, about 6 minutes. Graded in your browser: the value and the formula behind it, with feedback that names the fix.
How to solve it
- F2
=EOMONTH(C2,E2)
EOMONTH(start, months) returns the last day of the month that lies the given number of months after the start date — EOMONTH(C2,1) for a March invoice is 30 April, whatever day in March the invoice carries. Because the terms differ by customer, the months argument reads column E instead of a typed number, and the formula fills down unchanged. Date functions return serial numbers; the cell only looks like a date once it carries a date number format, which is why the second step exists.
Pitfall 1: EOMONTH, EDATE, DATE and WORKDAY all return bare serials in a General cell (46142 instead of 2026-04-30) — Excel auto-formats a plain =C2+30, but not function results; always format the answer column. Pitfall 2: EDATE(C2,1) is "same day next month", not the month end, and it clips 31 January to 28 February; for month-end terms use EOMONTH, for "net 30" use C2+30, for "30 days end of month" use EOMONTH(C2,0)+30. Pitfall 3: a start date stored as text ("2026-03-14" typed with an apostrophe or imported from CSV) makes EOMONTH return #VALUE!; convert with DATEVALUE first. Negative months look backwards (EOMONTH(C2,-1) is the end of the previous month) and EOMONTH(C2,0) is the end of the current month — handy for period-end accruals. The classic pre-EOMONTH idiom DATE(YEAR(C2),MONTH(C2)+E2+1,0) still works everywhere: day 0 of the following month is the last day of the target month. Version note: all of these functions exist in every Excel version; EOMONTH was once an Analysis ToolPak add-in function and is built in since Excel 2007.
Other ways that work
- =EOMONTH(EDATE(C2,E2),0) — move N months with EDATE, then jump to the month end
- =DATE(YEAR(C2),MONTH(C2)+E2+1,0) — day 0 of the following month, no EOMONTH needed
- =EOMONTH(C2,E2)+0 — identical value; some people add +0 to force a number before formatting
Common mistakes
Using EDATE alone: =EDATE(C2,E2) returns 2026-04-07 for INV-2026-0401 — the same day 3 month(s) later — instead of the month end 2026-04-30 the terms demand.
How we grade
Any formula that produces the right result is accepted, unless the task names a function: then another function earns half credit. We compare values with a small tolerance and ignore case and spaces in text. A correct number typed by hand instead of a formula earns half credit. Multi-cell tasks earn full credit at 100% of cells, half credit from 50%. Where it matters, we also change an input cell on a copy of your sheet and check that your formula follows.
Answers computed with Excel 365 rules and checked in our grading engine on November 16, 2026. Author: GridBelt team.