Deferred Revenue Schedule

Hi all,
I'm trying to create a deferred revenue schedule.

I've got three dates which are relevant;
1. Invoice date -> this is the date the invoice was created
2. Start date -> this is the date the service starts from (this can be in the past, current, future related to the invoice date)
3. End date -> this is the date at which the service ends

The amount and daily rates are all calculated off the number of days between the start & end dates.


The attached file works for when the start date is the same as the invoice date or is in the future, the issue I'm trying to figure out is when the start date is before the invoice.

Row 12 on this file shows an invoice issued in July, but the service was from May. The number for July should therefore include revenue for May, June & July all recognized in July and then flows normally after that, so it's effectively just catching up for the prior period - I can't seem to link this one and make it work easily.

Any help is appreciated!!!

Thanks
Dave

Fantastic, this works!!!

Thanks Glenn, really appreciated!

Actually, looks like the formula is only looking at months and not months & years - so if I rolled this forward for 2019, it would start over on a January invoice.