Hello,

I am hoping you can help me, I have been told I need to keep an eye on our business mobile phone bills, they are all on pro-rata billing.

I am trying to make a calculator in excel to double check this. So the the calculator should be as follows-

When did your contract start: 19/09/2017

What day of the month is your bill produced: 14

How much is your airtime tariff: £20

Total:

Hope you can help.

Thanks

Daniel