Date Functions
Intermediate

Payment terms: end of the following month

A positive offset moves forward by whole months.

Task:

Your supplier's terms are "payment due by the end of the month following the invoice". In B2:B6 give the due date for each invoice date.

Interactive Spreadsheet

Read about EOMONTH

Hints

+5 XPno-hints bonus

Solve it on your own to keep the bonus. Each hint gets one step closer to the formula.

Variations of EOMONTH

0/4

The same formula in the other shapes it takes at work.

  1. EOMONTH Function

    Find the last day of the month using EOMONTH.

    Core
    Intermediate
  2. The first day of the month with EOMONTH

    The end of last month plus one day.

    Intermediate
  3. Payment terms: end of the following month

    A positive offset moves forward by whole months.

    Intermediate
  4. How many days in the month?

    DAY of the month's last day is its length.

    Intermediate

The data in this exercise

This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.

6 rows × 2 columns5 cells you fill in
AB
1Invoice dateDue
21/5/2024
31/31/2024
46/15/2024
511/30/2024
612/1/2024
What this exercise teachesMay contain the answer

Adding 30 days gets month-end terms wrong whenever a month is not 30 days long. EOMONTH counts whole months and lands on the right last day, including 29 February in a leap year and the step into the next year in December.