formula to calculate total rent charges

[Guest]

The below is my List of date effecting and the size code.
23/05/2007 1 X 20
28/05/2007 3 X 40
15/06/2007 3 X 40
15/06/2007 2 X 20
17/06/2007 1 X 20
18/06/2007 3 X 40
19/06/2007 4 X 20
20/06/2007 2 X 20
24/06/2007 6 X 20
27/06/2007 1 x 40

for which I am trying to get a formula to calculate the total rental
charges to pay as on today by adding the prices depending on no. of days
from effecting date. Both the Tables below are to be applied to find out the
total rent charges. If the above Dates are in column A & sizes are in B can I
get the total amount in C?
RENTAL CHARGES-
DAYS 1 x 20 1 x 40

8 to 17 Days 19.00 38.00
18 to 32 Days 24.00 43.00
33 Days & above 30.00 48.00

SPACE RENT
8. to 14 Days 35.00 70.00
15 Days & above 70.00 140.00
Anybody can please help me?

 

[Guest]

Please e-mail me at:

toppers <at> NOSPAMjohntopley.fsnet.co.uk

and I will send a sample solution.

Can you also provide answers to the following, assuming TODAY = 07/07/07, so
I can check my results:

23/05/2007 1 X 20
17/06/2007 1 X 20
27/06/2007 1 x 40

 

[Guest]

Toppers,
I could not send it to this you email ID. Can you geve me any other
alternative email Id?
RENTAL CHARGES- SPACE RENT
days to be accounted 1 - 7th=8days @zero 8 - 17th=10days @19 18 -
32nd=15days @24 33+?days @24 total 1 - 7th=8days @zero 8 - 14th=7days @35 15+
?days @70 total Answer
1 23/05/2007 1 x 20 46 8days =0 10days =190 15days=360 13 days=420 46days
=970 8days =0 7days =245 31 days=2170 46days =2415 46days =3385
2 17/06/2007 1 x 20 21 8days =0 10days =190 3days=72 nil 21days =262 8days
=0 7days =245 6days =420 21days =665 21days =927
days to be accounted 1 - 7th=8days @zero 8 - 17th=10days @38 18 -
32nd=15days @43 33+?days @48 total 1 - 7th=8days @zero 8 - 14th=7days @70 15+
?days @140 GRAND TOTAL
3 27/06/2007 1 x 40 11 8days =0 3days=114 nil nil 11days =114 8days =0 4days
=280 nil 11days =280 11days =394

Please copy this to excel & check it

As on 07/07/07, 46 days t0 be taken into account.

 

[Guest]

sorry ... forget to say remove NOSPAM

toppers <at> NOSPAMjohntopley.fsnet.co.uk

 

[Guest]

I believe some of your calculations are incorrect: check number of days in
the various ranges.