Deferred Revenue Schedule for SaaS

I am attempting to create a deferred revenue schedule for a hypothetical SaaS company.

Provided info:
-Start Date
-End Date
-Annual Rate

10 of the customers begin their service on the first of the month. However, the remainder of the customers begin their service/end their service in the middle of the month. The deferral of the revenue will be on a daily basis, not an even monthly amount.

If i were to create a revenue schedule with the months as the columns, customer amounts as rows, is there a single formula which could correctly allocate this revenue in each cell?

Thank you all in advance, happy to extrapolate on anything that is needed.