Prorated charges

[Giri.hb]

Hi Team,

I have checked in other post and found formula to calculate the prorated charges but my issue is that using that formula I am not able to calculate the pro rata charges in between two months. Please find the attached spread sheet for your reference, 2nd Row the formula applied correctly but for third row I am getting incorrect value. Kindly check and do the needful. Thank you.

Regards,
Girish

[bebo021999]

In D2:

=A2*(C2-B2+1)/DAY(EOMONTH(B2,0))

is your expected result

Copy down to D3, become 1046.52,

But you expected 1015.74, it is from below
(Not +1 )
=A3*(C3-B3)/DAY(EOMONTH(B3,0))

What is your final expected result?

[Giri.hb]

Thank you for the response, expected result for row 3 is 1015.74. please find the attached updated spread sheet where I have split the Row 3 for your reference. kindly do the needful.