Day 85 · Tuesday, 27 October 2026

From the archive

Intermediate

Work Out "End of Next Month" Payment Due Dates with EOMONTH

A supplier's "due at the end of the month after invoice" terms aren't a fixed number of days — they're a calendar position, and EOMONTH lands on that position directly instead of guessing at it with +30.

Task:

You run accounts payable for a small manufacturer. One supplier bills on EOM+1 terms: every invoice is due on the last day of the month after the month it was issued in, however early or late in that month it was dated. In column C, use EOMONTH to find each invoice's due date. In column D, find how many days are left until it's due, counting from the report date in B1 — a negative number means the invoice is already overdue. Fill in rows 3 through 7.

The daily challenge is part of Pro

A new exercise every morning, plus every day that came before it — a back catalogue that grows by one a day, whether or not you were here for it.

Every day so far

August 2026

September 2026

October 2026

November 2026

18
SolvedOpenProLatest

Recent days

The last 14 days. Today's challenge is free while your streak is alive; Pro opens every past day too.