A wrong due date means either a late payment or cash paid out earlier than needed.
For net terms, add the days to the invoice date. For end-of-month terms, use EOMONTH. Then move any due date that lands on a weekend or holiday with WORKDAY, using a holiday list in its own range. Finally, assign each invoice to the payment run date that falls on or before its due date.
For terms such as net 30, with the invoice date in B2 and the number of days in C2:
=B2+C2
Check your contracts: some terms run from the invoice date, others from the date the invoice was received or the goods delivered. Use the date the agreement specifies.
"30 days end of month" usually means 30 days after the end of the month in which the invoice is dated:
=EOMONTH(B2,0)+30
"Payment by the end of the following month" is:
=EOMONTH(B2,1)
EOMONTH(date, 0) returns the last day of the same month; EOMONTH(date, 1) the last day of the next month.
For terms such as "the 25th of the month after invoice":
=DATE(YEAR(EOMONTH(B2,0)+1),MONTH(EOMONTH(B2,0)+1),25)
EOMONTH(B2,0)+1 is the first day of the next month, and DATE builds the 25th of that month, handling the year change in December.
List public holidays in a range named Holidays. To move a due date that falls on a non-working day to the next working day:
=WORKDAY(D2-1,1,Holidays)
Starting from the day before and adding one working day returns the date itself if it is a working day, or the next working day if it isn't. To move to the previous working day instead, use =WORKDAY(D2+1,-1,Holidays). Which one you need depends on your terms and on when your bank processes payments.
If your working week isn't Monday to Friday, WORKDAY.INTL lets you choose the weekend days.
For terms like 2/10 net 30, calculate both dates:
Discount date: =B2+10
Full due date: =B2+30
Flag invoices whose discount date falls before the next payment run, so they are approved in time. See early payment discounts.
With the run dates listed in ascending order in a range named Runs, the last run on or before the due date is:
=IFERROR(LOOKUP(2,1/(Runs<=E2),Runs),"Before first run")
Invoices due before the first listed run need to go in an earlier, extra run. Review the list weekly as part of the payment run checklist.
Store each supplier's terms in the supplier master, not typed into formulas, and show the calculated due date next to the invoice. When a supplier says a payment was late, you can see exactly how the date was worked out.
Holiday lists differ by country and, in the US, sometimes by bank. UK and US laws on late payment and interest differ; check the rules that apply to your contracts rather than relying on the formulas alone.
Paste your invoice list and see likely duplicates in minutes. Free Excel file: enter your work email to download it.
The Accounts Payable Control System runs four duplicate-invoice tests, supplier master fraud checks and a three-way match on every invoice, with a payment run release gate that blocks release while exceptions are open. Excel, no macros, one-time price.
WORKDAY(start, 1) always moves at least one working day. Starting one day earlier means a due date that is already a working day stays the same.
Use the receipt date in place of the invoice date. Record the receipt date when the invoice arrives so the calculation has something to use.
Yes. EOMONTH returns the correct last day for every month, including leap years.
Last updated 04 November 2026. General guidance for finance teams; check it against your own policies, systems and local rules.