+ Reply to Thread
Results 1 to 4 of 4

Excel dummy needs help!!!

Hybrid View

brianerdelyi Excel dummy needs help!!! 09-11-2006, 06:45 PM
brianerdelyi i did some more research but... 09-12-2006, 12:55 AM
daddioja I think you can do this with... 09-12-2006, 02:34 AM
brianerdelyi That is exactly what I was... 09-12-2006, 09:57 AM
  1. #1
    Registered User
    Join Date
    09-10-2006
    Posts
    6

    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

  2. #2
    Registered User
    Join Date
    09-10-2006
    Posts
    6
    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

  3. #3
    Registered User
    Join Date
    06-01-2006
    Posts
    36
    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.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    09-10-2006
    Posts
    6
    That is exactly what I was trying to do! Thank you so much for your help.

    Brian

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1