# How to calculate a due date with Net 30 end-of-month terms in Excel

Start the count at the end of the invoice month: `=EOMONTH(B2,0)+30`.

**Excel:** `=EOMONTH(B2,0)+$F$1` (Every current version)

**Google Sheets:** the same formula works.

## Example

Sample data (row 1 is the header):

| A | B | C | D | E | F |
| --- | --- | --- | --- | --- | --- |
| Invoice | Invoice date | Due date |  | Days after month end | 30 |
| INV-7101 | 2026-01-08 |  |  |  |  |
| INV-7102 | 2026-02-20 |  |  |  |  |
| INV-7103 | 2026-03-31 |  |  |  |  |
| INV-7104 | 2026-06-05 |  |  |  |  |
| INV-7105 | 2026-12-14 |  |  |  |  |

Formula in C2, filled to C6: `=EOMONTH(B2,0)+$F$1`

Result: 3/2/2026; 3/30/2026; 4/30/2026; 7/30/2026; 1/30/2027

## How it works

With end-of-month terms the clock starts at the end of the invoice month, not on the invoice date. `EOMONTH(B2,0)` finds that month end, and adding the days in F1 gives the due date, so every January invoice is due on March 2.

## Other ways

- `=EOMONTH(B2,1)`: Some suppliers read "Net 30 EOM" as the end of the following month. (Due on the last day of the next month.)
- `=B2+$F$1`: Plain Net 30, counted from the invoice date. (Counts from the invoice date.)

## Common mistakes

- Terms wording varies. Confirm whether "EOM" means 30 days after the month end or the end of the next month.
- A due date on a weekend usually moves to the next business day: `=WORKDAY(EOMONTH(B2,0)+$F$1-1,1)`.

## Questions

**How do I calculate "2/10 Net 30" dates?**

The discount deadline is `=B2+10` and the net due date `=B2+30`.

**How do I calculate "due on the 10th of the following month"?**

`=EOMONTH(B2,0)+10`.

Every formula and result on this page was checked by running it in the Spreadsheet Practice formula engine on 2026-10-30.

Source: https://spreadsheetpractice.com/formulas/net-30-end-of-month-due-date