Net 30 invoice due dates: calculate from the terms you agreed

Confirm the starting event and the day-count rule

Find the accepted terms in the agreement or order. Write down the starting event, whether the period uses calendar or business days, and any agreed rule for weekends or holidays. If the agreement gives a specific payment date, record that date rather than replacing it with your own calculation.

The Small Business Commissioner warns that “30 days” can be understood differently and recommends confirming the expected payment date with the customer. Ask about an ambiguity while there is still time to resolve it: “Are these 30 calendar days after issue on 3 November, giving a due date of 3 December?”

A customer's later internal approval date does not, by itself, tell you to overwrite the existing agreed date. Record the processing update separately and clarify any proposed change. This worksheet calculates a stated agreement; it does not determine legal payment rights where terms are missing or disputed.

Compare three fictional terms before calculating

These fictional examples all concern an invoice issued on 1 November 2026. “After” means the following day is day one in the first two examples.

Thirty calendar days is also different from one calendar month. For example, 31 January 2026 plus 30 days is 2 March 2026. In the leap year 2028, 31 January plus 30 days is 1 March. Moving to the same numbered day of the next month would answer a different question.

Use explicit dates for a reproducible Excel check

Microsoft documents adding a number of days directly to an Excel date. Copy each formula into a separate cell and format the results as dates. DATE uses year, month, day arguments, avoiding an ambiguous typed date such as 03/11/2026.

=DATE(2026,1,31)+30
=DATE(2028,1,31)+30
=DATE(2026,11,3)+30

The expected results are 2 March 2026, 1 March 2028 and 3 December 2026 respectively. Check them in your worksheet before replacing the examples with business data. If your formula settings use semicolons, replace argument commas with semicolons. Do not use these formulas for an agreement that specifies business days.

Save the reason for the date alongside the date

Record the wording, supporting agreement, starting event and resulting date together. For a receipt-based term, keep the confirmed receipt date and its source. If that evidence is missing, make the next action “confirm receipt date”, instead of silently choosing the issue date.

Check the final date against your invoice details, then use the reminder calendar to choose appropriate contact dates. The due date states the agreement; the next follow-up date states your action. Keep both so a rescheduled follow-up does not accidentally become a rewritten payment term.