Weekly Hire

[Guest]

Hi,
Is there a way to calculate an amount continuity (weekly) until an end date
is put in.

The scenario is that i want to see the weekly hire cost of some equipment
however various items come and go on/off hire at different times?



Many Thanks

H

 

[Fred Smith]

The answer is yes. Can you give us an idea of the data you have, and the outcome
you want.

 

[Guest]

Hi
I have a large no of items on hire, these vary form week to week, i want to
be able to get accurate weekly costs for the hire of these items. I am
looking for a formula to populate the 'weekly total' column. a formula that
times the number of items by their hire rate from an 'on hire' date. i want
this formula to keep picking up this value until i enterr an 'off hire date'
where by my charges will stop. the columns are weekly ie a start date the +7
days on going. so the range will be ifthe on hire occurs with in the week/or
the off hire to stop the cost.

i hope this helps

H

 

[Fred Smith]

It doesn't help very much. Telling us specifically what's in each column, and
the results you want would help more.

Surely the formula for hire costs is:

=WeeklyRate * NumberOfWeeksHired

If you have a start and stop dates, the total cost is:

=(EndDate - StartDate) / 7 * WeeklyRate

If you are saying you don't have an EndDate yet, but still want to know the
costs so far, use something like:

=(if(EndDate=0,Today(),EndDate) - StartDate) / 7 * WeeklyRate