Hi everyone,
I currently have a formula that will calculate the date I will next need to buy diesel, based on the current mileage left in my tank and the average miles travelled per day. It also takes into account weekends and Bank Holidays. What it can't do is take into account days when I do extra mileage.
Example:
I have 300 miles left in my tank.
I normally travel 30 miles/day.
Result = I need to buy diesel in 9 working days (I deduct 1 day as I don't want to run out of fuel all together )
Quandary:
In 3 days time I will be doing an extra 60 miles for a day trip. This would mean I need to buy fuel in 7 working days.
However, if the extra miles were to be done on the 9th working day, I would need to buy the extra fuel on the 8th working day.
It seems so simple to work this out in my head, but I can't think of a way to do this with a formula. Can anyone help please?
tyvmia
Bookmarks