Thank you Excel Wizard it works well.Please try at Q3
1-31 Jan is 31 days
15-31 Jan should be 17 days/31 days
Thank you John,Hi to all!
I think that year must be calculated over 360 days. If so... check this formula:
Check file. Blessings!
Hi, Ranjit!Thank you John,
360 days is new perspective and it works.
But in the row 7 sample fraction jan-20 value should be 5940.85
For rows 3 ,4 & 5 effectiveness of formula is confirmed in cross checks summed in cell AE & AF.