I have a table that contains a nightly rate for a holiday home. At the moment I manually take the range a customer is staying and total the cost.
I would like to be able to calculate the total length of the customers stay by entering the date from and to.
As an example: If the customer arrives on 19 Jun and checks out on 29 June
Can anyone help with this as I only know basic Excel functions.
Thank you in advance
Bookmarks