Hello all! I hope someone can help.
I'm putting together a tracker & forecast for invoices paid/to be paid for leased vehicles. We are invoiced two months in advance (e.g. in June we we invoiced for August's rental costs).
The basic format is currently something like shown in the attached screen cap. The problem being that the costs are calculated using the formula entered manually (shown in the formula bar up top), and these will not change automatically if and when the vehicle return dates are amended, obviously.
While the invoice costs per vehicle are quoted on a monthly rate, I would like the cost to break down by the day for when vehicles are return mid month. For this purpose I'm content that all months effectively be 31 days, hence my horrible clunky formula shown!
Am I being daft, and not seeing an obvious way around this? Any help or suggestions will be massively appreciated.
Bookmarks