How to calculate a due date with Net 30 end-of-month terms in Excel
Formula (Excel and Google Sheets)
=EOMONTH(B2,0)+$F$1Start the count at the end of the invoice month: =EOMONTH(B2,0)+30.
- Result on the example
- one result per row in
C2, filled down toC6 - Works in
- Every current version
- Google Sheets
- Same formula
See it work
The formula is already in C2, filled down to C6. Change any input and the result updates, or edit the formula to experiment.
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.
=EOMONTH(B2,0)+$F$1Result46083
B21/8/2026The value in B2.
EOMONTH(B2,0)1/31/2026 (46053)EOMONTH: Last day of the month, months away.- start_date
B21/8/2026 - months
0
- start_date
$F$130The value in F1.
EOMONTH(B2,0)+$F$146083The + operator adds.
In Google Sheets
The same formula works in Google Sheets: =EOMONTH(B2,0)+$F$1. We ran it in Google Sheets mode on the same data and it returns the same results.
Other ways to do it
Each one was run on the same example sheet.
| Formula | Result | When to use it |
|---|---|---|
| =EOMONTH(B2,1) | 2/28/2026, 3/31/2026, 4/30/2026…Different result | 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 | 2/7/2026, 3/22/2026, 4/30/2026…Different result | 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).
Try it yourself
Same data, empty answer cell. Your formula is graded instantly, then re-checked on changed data, so a typed-in number won't pass.
Calculate a due date with Net 30 end-of-month terms
C2, calculate the due date as the number of days in F1 after the end of the invoice month, and fill down to C6.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.
Checked by running on 2026-10-30: every formula and result on this page was calculated by the Spreadsheet Practice formula engine, in both Excel and Google Sheets modes.