Due Dates & Payment Terms: Net Days, WORKDAY and EDATE
This lesson is part of the course
In this lesson
You turn payment terms into due dates, move due dates off weekends and holidays with WORKDAY, find the early-payment deadline in business days and schedule monthly retainer invoices with EDATE.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Line Items: Quantity × Price, Line Discounts & Net Amounts Locked
- Product Lookup from a Price List: Descriptions, Bulk Prices & Unknown SKUs Locked
- Tax per Line, a Tax Summary per Rate & the Rounding Difference Locked
- Invoice Numbering: Prefix + Year + Padded Counter with TEXT Locked
- Due Dates & Payment Terms: Net Days, WORKDAY and EDATE Locked
- From Quote to Invoice: Validity, Accepted Lines & the Deposit Invoice Locked
- Payment Log & Open Balance per Invoice with SUMIFS (and a Chart) Locked
- Customer Statement & Ageing Summary (with Overdue Highlighting) Locked