Overlap Days Between Two Periods: Splitting an Invoice Period Across Months
This lesson is part of the course
In this lesson
You split five fictional service invoices across January to April: count each invoice's days, find the overlap of every invoice with every month in one copyable formula, turn the overlap into amounts and see which month carries the most.
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
- Daily Rates Three Ways: Actual Days, a 30-Day Basis & Annual ÷ 365 Locked
- Partial First and Last Months: Days Used, Days in the Month & the Prorated Charge Locked
- Joiners and Leavers: Calendar-Day vs Working-Day Proration of a Monthly Salary Locked
- Mid-Cycle Plan Changes: Credit for the Old Plan, Charge for the New One & the Net Amount Locked
- Overlap Days Between Two Periods: Splitting an Invoice Period Across Months Locked
- Spreading Annual Amounts: a Licence Across Months and Fiscal Years Locked
- Rounding That Adds Up: Rounded Parts vs the Total & Where the Difference Goes Locked
- Proration Dashboard: Many Contracts, Monthly Totals, Checks & a Chart Locked