# Accrued daily costs

#### yesman

##### New Member
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

### Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

#### yesman

##### New Member
=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

Replies
1
Views
168
Replies
7
Views
423
Replies
2
Views
228
Replies
6
Views
448
Replies
2
Views
234

1,190,579
Messages
5,981,761
Members
439,733
Latest member
hmopheim

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back