EDATE

You test the prepaid expenses (vooruitbetaalde kosten) of Veldhuis Installatie BV at 31 December 2025. Four annual insurance premiums were booked as INK entries. Each policy runs for 12 months from its start date and renews on the same day of the month. You want the renewal date next to every entry, to see which premiums still cover a period after year end.

Formula in C2

=EDATE(B2, 12)

=EDATE(B2; 12)

Result: 15 Mar 2026

Watch out: B2 + 365 gives the same answer here, but for a start date less than a year before a leap day, such as 1 Mar 2027 + 365, it lands on 29 Feb 2028 instead of 1 Mar. Use EDATE for anniversaries.

=EDATE(B2, 12) - 1

=EDATE(B2; 12) - 1

Veldhuis Installatie BV took a bank loan that was paid out on 31 August 2025. It is repaid in six monthly instalments of 4,0004.000, due on the same day of the month. Several months have no 31st.

You recalculate the due dates to agree them to the bank confirmation (bankbevestiging). The start date sits in E1 and the instalment number in column A; one formula, copied down, gives every due date.

Formula in C2

=EDATE($E$1, A2)

=EDATE($E$1; A2)

Result: 30 Sep 2025

Watch out: If the instalment number in column A is blank, months is 0 and EDATE returns the start date itself, 31 Aug 2025, which looks like a valid due date.

=EOMONTH($E$1, A2)

=EOMONTH($E$1; A2)

You assess the lease term of the rented premises and vehicles of Veldhuis Installatie BV. The contract list gives a start date, a term in months and a notice period in months. A contract ends the day before its anniversary, and notice must be given no later than the notice period before that end date.

From the deadline you see whether the company could still terminate at year end 2025 or is committed to another term. You want the deadline in one formula, with the end date calculated inside it.

Formula in E2

=EDATE(EDATE(B2, C2) - 1, -D2)

=EDATE(EDATE(B2; C2) - 1; -D2)

Result: 30 Jun 2026

Watch out: EDATE(B2, C2 - D2) - 1 looks shorter and gives the same date for H-501, but for H-502 it gives 1 Sep 2026 - 1 = 31 Aug 2026, one day later than 30 Aug. Subtracting the day before or after moving changes the answer; follow the order of the contract wording.

=WORKDAY(EDATE(EDATE(B3, C3) - 1, -D3) + 1, -1)

=WORKDAY(EDATE(EDATE(B3; C3) - 1; -D3) + 1; -1)

You test the completeness of recurring supplier invoices (INK) at Veldhuis Installatie BV. Each contract has a first invoice date and a number of monthly invoices. The policy in the contracts: an invoice dated on the last day of a month is dated on the last day of every following month.

EDATE alone fails that for a first invoice on 30 Sep, because it keeps day 30 and gives 30 Dec, not 31 Dec. One formula per contract spills the expected dates across the row, choosing EOMONTH for month-end starts and EDATE for the rest, so you can look each date up in the auditfile.

Formula in D2

=LET(
  start, B2,
  n, C2,
  k, SEQUENCE(1, n),
  monthEnd, start = EOMONTH(start, 0),
  IF(monthEnd, EOMONTH(start, k), EDATE(start, k))
)

=LET(
  start; B2;
  n; C2;
  k; SEQUENCE(1; n);
  monthEnd; start = EOMONTH(start; 0);
  IF(monthEnd; EOMONTH(start; k); EDATE(start; k))
)

Result: 31 Oct 2025 | 30 Nov 2025 | 31 Dec 2025 | 31 Jan 202631 Oct 2025 | 30 Nov 2025 | 31 Dec 2025 | 31 Jan 2026

Watch out: The mirror-image mistake is EOMONTH(start, k) for every contract. It is right for R-201 and R-203, so a test on those passes, but R-202 then expects invoices on 31 Oct, 30 Nov, 31 Dec instead of the 15th.

=EDATE(B2, SEQUENCE(1, C2))

=EDATE(B2; SEQUENCE(1; C2))