Deferred Revenue Schedule for SaaS

Try this in cell K2 and then copy across/down.
=MAX(0,$G2*(MIN(EOMONTH(K$1,0),$C2)-MAX($B2,K$1)+1))
Attached is the file.

This is it! Can't thank you enough.

Seriously, thank you.

Originally Posted by Gregb11

Try this in cell K2 and then copy across/down.
=MAX(0,$G2*(MIN(EOMONTH(K$1,0),$C2)-MAX($B2,K$1)+1))
Attached is the file.

This is it! Can't thank you enough.

Seriously, thank you.