Building an Invoicing tool for my Bed and Breakfast/ Need help with the following:
- How to I set Standard Rates for Weekends/Weekdays are selected? (User inputs Dates and then they are displayed these Standard Rates)
- If their input in “Number of Guests” input box is >10 transfer the number of Guests >10 to “Additional Guests” (For example input=16; Number of Guests becomes “10” and Additional Guests becomes “6”)
- Add a Cost to Every Additional Guest (For example each guest above “10” is charged $20 per Guest; so “6” automatically calculates $120.