Prepaid quaterly allocation based on starting date

[sabari161]

Boss..,

Gud day to you..,

Will appreciate if you send me formula for attached file against Sub issue

Thanks in advance

 

[S. Das]

sabari161, I think you should share the correct result by doing the manual calculation along with the formula you made. Because without the correct result it is very much difficult to answer whether the formula is correct or not. Or you can share the calculation logics as well.

 

[sabari161]

Boss...,

This is related with Quarterly Prepaid allocation based on dates lying on particular Qtr for given year

 

[S. Das]

@sabari161, I don't have any idea about "Quarterly Prepaid allocation".
Please explain the logic of calculation.