Paste your invoice list — one per line, date, terms — and get every due date at once. No formulas, no drag-fill mistakes. Your data never leaves the browser.
| Invoice date | Terms | Due date | Status |
|---|
Paste a list above (or fill the sample) to see every due date.
IF/EOMONTH formulas.Only need one due date? Use the single invoice calculator.
Keep using Excel or Google Sheets by all means — here are the formulas that actually handle the edge cases, the ones most templates get wrong:
=A2+B2 where A2 is the invoice date and B2 the term days. Excel stores dates as serial numbers, so plain addition works.=EOMONTH(A2,0) returns the last day of the invoice month; =EOMONTH(A2,0)+15 gives EOM + 15.=IF(WEEKDAY(C2,2)>5, C2+(8-WEEKDAY(C2,2)), C2) — if the due date lands on Saturday or Sunday, push it to Monday.=NETWORKDAYS(A2,C2,Holidays) where Holidays is a named range of federal holiday dates. The UK equivalent NETWORKDAYS.INTL handles non-standard weekends.=WORKDAY(A2,B2,Holidays) — note this starts counting the next working day, matching the convention on the business days calculator.=A2+30 then returns #VALUE!. Fix with DATEVALUE() before any arithmetic.That list is exactly why the paste-a-list tool above exists: the same rules, executed the same way every time, with a holiday table maintained for you through 2028. Cross-check a handful of rows against the single invoice due date calculator after any formula change.
Paste these three lines and the tool returns one due date for each, computed by the same engine every time. The numbers below are the exact calendar results:
| Invoice date | Terms | Due date (calendar days) |
|---|---|---|
| 2026-01-15 | Net 30 | 2026-02-14 (Sat) |
| 2026-02-01 | EOM | 2026-02-28 (Sat) |
| 2026-03-10 | Net 45 | 2026-04-24 (Fri) |
Two of the three deadlines land on a Saturday. On calendar terms the due date does not move — the contract says what it says — but nobody settles an invoice on a Saturday, so the money arrives on the Monday. That is the single most useful thing this tool shows that a bare formula does not.
Switch the same batch to business-day mode and the fifteen January invoice moves from 14 February to 26 February — a twelve-day difference caused entirely by how the term is counted. Before you build a payment run around any deadline, decide which convention the contract actually uses, then set the whole list to that mode. Getting this wrong is how a comfortable Net 30 turns into an awkward phone call the week rent is due.
Copy all puts every row on the clipboard as tab-separated text you can paste straight into a spreadsheet column. Export CSV writes a standard comma-separated file with your original columns plus the calculated due date, so it opens back up in Excel, Numbers or Google Sheets with no import wizard. Neither button uploads anything — the file is assembled in your browser and saved locally.
An invoice due date calculator turns two inputs — the date you issued the invoice and the payment terms — into the one date that actually matters: the day the money is contractually owed. In its simplest form it is the invoice calculator every freelancer keeps in their head: issue on 15 January on Net 30 terms and payment is due on 14 February. An invoice payment calculator does the same job for a whole ledger at once — which is this tool.
It is worth automating because the terms are rarely just a count of days. Net 7, Net 15, Net 30, Net 45, Net 60 and Net 90 are the common ones, but you also meet EOM (the last day of the invoice month), EOM + 15, and clauses that count working days rather than calendar days. Each changes the answer by days or weeks, and each is a place where a hand-built sheet drifts out of step with the contract.
| Terms | What it means | An invoice dated 2026-01-15 is due |
|---|---|---|
| Net 30 | 30 calendar days | 2026-02-14 |
| Net 45 | 45 calendar days | 2026-03-01 |
| Net 60 | 60 calendar days | 2026-03-16 |
| Net 90 | 90 calendar days | 2026-04-15 |
| EOM | Last day of the invoice month | 2026-01-31 |
| EOM + 15 | 15 days after month end | 2026-02-15 |
If you are determined to keep the calculation in a spreadsheet, two functions carry almost all of it. To add a fixed term to a date, =A2+30 is enough, because Excel stores dates as serial numbers and plain addition moves the date forward. To add working days while skipping weekends and holidays, =WORKDAY(A2,30,Holidays) is the correct tool; for EOM terms, =EOMONTH(A2,0) gives the last day of the invoice month.
The function you should not reach for is DATEDIF. DATEDIF measures the distance between two dates in days, months or years — it tells you how far apart two dates are, not where a future one lands. It is also an undocumented function that Excel does not even autocomplete, and it returns #NUM! if the end date falls before the start date. To find a due date you want date arithmetic (add days) or WORKDAY (add working days), not a difference. DATEDIF answers "how many days were we late?", not "when is this due?".
Whatever route you take, the results on this page all come from one engine implementing the same rules, so pasting your list above gives you the answer a correct formula would have produced — without maintaining a formula. Need just one date? The invoice due date calculator handles a single invoice.
No. Parsing, computing and export all happen in your browser — nothing is transmitted or stored.
ISO format (2026-11-03), US format (11/03/2026) and most spreadsheet exports. Ambiguous formats like 03/11/2026 are read as month first, matching US convention — check one row against the results before processing the whole list.
Yes — the calculation is instant for tens of thousands of rows. The practical limit is your browser tab's memory, not the maths.
Yes. Switch the day-counting mode to business days and the whole list is recalculated at once. Weekends are skipped, and you can add an option to skip US federal holidays as well. A Net 30 invoice dated 15 January 2026 is due 14 February on calendar days but 26 February on business days.
Type the term exactly as you would on the invoice — EOM for the last day of the invoice month, or EOM + 15 to add fifteen days to it. A 1 February 2026 invoice marked EOM is due 28 February; the same invoice under EOM + 15 is due 15 March.
Yes. In business-day mode, tick the holiday option to also skip the US federal holiday schedule. That is what stops a payment deadline quietly landing on a bank holiday that a plain spreadsheet formula would miss.
The tool flags that row in the results instead of guessing — it is shown as an error row rather than given a wrong due date, so one bad line never corrupts the rest of your register. Fix the source line and re-paste.
Yes. Export CSV writes a standard comma-separated file with the original columns plus the calculated due date, so it opens straight back in Excel, Numbers or Google Sheets with no import wizard.
Formula behaviour verified against current documentation on September 29, 2026.
Missing a feature or found something off? Tell us — user suggestions decide what we build next.