Excel dummy needs help!!!

I need help!

I organize an anual house boat trip which has grown to be quite large. I am looking to update my spread sheet and make it a little more automated. I need a way to calculate the guests total amount due based on the following information:

1. a 7 day stay = $85 per day charge if paid in full by to 01/01/01
a 7 day stay = $100 per day charge if paid on or after 01/02/01

2. a 6 day or less stay= $100 per day charge if paid in full by to 01/01/01
a 6 day or less stay= $115 per day charge if paid on or after 01/02/01

My old spread sheet works well but it cant calculate the payment discount / penalty as it applies to the pay date.

The amount per day charge is currently in a cell on the spread sheet. Once i deterine that amount for the year i can lock the sheet. Then the only user input on the sheet should be the guest name, the pay date, and the number of days stayed.

I tried to figure this out but its over my head. I would really appreciate any advise or formulas you could offer up. Thanks in advance!!!

Brian

i did some more research but i cant figure out how to use he date in my formula. Any help would be greatly appreciated. Thanks,

Brian

I think you can do this with some simple if statements. Here is an idea. I broke it down with an extra step in the rate column, but I would probably get rid of it and just use the amount due column.

Re the dates. You need to use the DATE function in the formula.

That is exactly what I was trying to do! Thank you so much for your help.

Brian