Deferred Revenue Help

Hi,

I have a spreadsheet attached. I am trying to have columns M thru X calculate the deferred revenue based on the number of months in column K. For instance, for absegami high school, I want the amount deferred to spread over feb, march, april, may, jun, july since it is only six months. Would greatly appreciate any advice. And if I change column k to "7", then it would spread to august. Thanks

Try:

Formula:

Please Login or Register  to view this content.

Good luck!

Thank you so much! Greatly appreciate your help