Accrued daily costs

[yesman]

Good morning everyone,

Thanks for all the really useful information on these boards they have helped me no end but I have hit a brick wall.

Here is the problem.

I am creating a simple spreadsheet which will allow me to monitor all items I have on hire. I have created the spreadsheet and included all of the columns I need. I have created fields to show date hired, date off-hired and a column that shows daily and weekly hire costs as well as a column that shows the current cost of hire based on the daily rate.

I am having trouble working out the formula to stop accruing costs when the 'date off-hired' date is entered.

This is what I need to show.

The current cost of hire based on daily hire costs, changing to weekly hire cost when 7 days since the 'date hire' date is reached. I then need the cost to stop accruing when a 'date off-hired' date is entered.

I hope somebody can help me as I am really stumped. Have a good day.

Thanks

 

[yesman]

=IF(ISBLANK(D1),INT(NOW())-C2*100%/1*k2)

This is where I have got to so far. Although it's not right.

Date hired is in C2, Date off-hired is D2, Daily hire rate is in K2 and weekly hire rate is in L2. The cell the formula is being written in is in M2.

I hope this makes sense...

Good morning everyone,

Thanks for all the really useful information on these boards they have helped me no end but I have hit a brick wall.

Here is the problem.

I am creating a simple spreadsheet which will allow me to monitor all items I have on hire. I have created the spreadsheet and included all of the columns I need. I have created fields to show date hired, date off-hired and a column that shows daily and weekly hire costs as well as a column that shows the current cost of hire based on the daily rate.

I am having trouble working out the formula to stop accruing costs when the 'date off-hired' date is entered.

This is what I need to show.

The current cost of hire based on daily hire costs, changing to weekly hire cost when 7 days since the 'date hire' date is reached. I then need the cost to stop accruing when a 'date off-hired' date is entered.

I hope somebody can help me as I am really stumped. Have a good day.

Thanks