What I'm trying to do is to create a Google Sheet to check my internet bill, but something doesn't seem to work.
FROM TO TOT DAYS PRICE CALCULATED PRICE OF BILL
5/3/2020 30/4/2020 57 € 47.31 € 47.23
NOTE:
My Subscription Price per month € 24.90
Bill received € 47.23
Why there is difference between the price calculated by me and the price of the bill received by the provider?
Formula I Used:
TOT DAYS =SUM(B2-A2)+1
Price calculated =SUM(C2*(24.9/30))