hi
i have check in and check out date for each guest
i need a formula to calculate how many night each guest stayed in a room for each month. Thant means if i have u guest checking in 01 jul and check out 11 jul then we can easily find that he stayed 10 nights in July, but if i have u guest that checks in on 28 jul and checks our 5 august then i need to calculate how many nights he stayed in july and how many night in august. Any clue any help. Thank you
Bookmarks