The Payment Schedule: Deposits, Due Dates with WORKDAY & EDATE, and What Is Still Open
This lesson is part of the course
In this lesson
You calculate every vendor's deposit, its due date ten working days after booking and the balance due date a set number of months before the wedding, then total what is still open.
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
- Splitting the Wedding Budget: Shares, Remaining Amounts & Over-Budget Flags Locked
- The Guest List: RSVPs, Plus-Ones & the Catering Headcount Locked
- Cost per Guest: Tiered Catering Prices with XLOOKUP and Bar Package vs Consumption Locked
- Choosing Vendors: a Weighted Scoring Matrix with SUMPRODUCT and RANK.EQ Locked
- The Payment Schedule: Deposits, Due Dates with WORKDAY & EDATE, and What Is Still Open Locked
- Seating: Tables Needed with ROUNDUP, Guests per Table & Empty Seats Locked
- The Savings Plan: Months to Go with DATEDIF and the Monthly Amount with PMT Locked
- The Wedding Dashboard: Spend vs Budget, RSVP Progress & Open Payments Locked