Hi All,
I have been hanging around the forum a lot of late and have found it incredibly helpful. Thanks for that.
I am totally stuck on something that I hope somebody can help with.
I have attached the spreadsheet to illustrate my problem.
I have a date hired and a date off-hired column, along with daily hire costs and weekly hire costs.
I have managed to enter a formula that calculates the cost accrued since the date of hire, and also conditional formatting to highlight when a hired item is over the expected number of hire days.
What I am struggling with is two things.
1) Getting the current total to switch to 'weekly rate' after 5 days
2) Getting the current total to stop accruing costs when data is entered into the 'off-hired' column.
I hope somebody here can help.
ThanksBuyers-hire.xlsx
Bookmarks