I have written an Excel formula to keep track of my usage since the previous bill - I expect that some people on this forum have done the same or similar. I can now enter my current reading and see exactly what my next bill will be, including VAT. Now the technical part: I have calculated the days elapsed since the last bill using the DATEDIF function and this reads the two dates from two cells on the sheet. I would like to incorporate this into my main formula but I can't see a way of doing this. I'd be interested to see any formulae that forum members have developed (Excel or other).
My attempt so far (which does work) is =SUM(((i4*29.64)+(j3*32.15))/100)*1.05
i4 contains a cell returning the difference between the last reading and today's
j3 contains the results from a cell calculating the DATEDIF function elsewhere on the sheet from the last bill date to today (using the TODAY() function)
29.64 is my unit cost in pence.
32.15 is my daily charge in pence.
1.05 is the VAT on the whole thing (unless Rishi has a change of heart soon).
Any comments or suggestions would be very welcome.
My attempt so far (which does work) is =SUM(((i4*29.64)+(j3*32.15))/100)*1.05
i4 contains a cell returning the difference between the last reading and today's
j3 contains the results from a cell calculating the DATEDIF function elsewhere on the sheet from the last bill date to today (using the TODAY() function)
29.64 is my unit cost in pence.
32.15 is my daily charge in pence.
1.05 is the VAT on the whole thing (unless Rishi has a change of heart soon).
Any comments or suggestions would be very welcome.