Hi!
New here, I'm struggling with a formal I wasn't able to find on the web.
I'm working for a hotel, and I would like to show if the bookings have a Saturday included or not.
Problem: the dates include the time..
I have the IN date:
and the OUT date:
I would need to show if those bookings include the night of Saturday in them, but I am struggling, could you help me please?
Ideally I would like to add a column at the end (let's name it: includes Saturday), and have an answer "Saturday", or just leave the cell blank if not.
Note: on this example, please take into account that the last night is the 11st (check out on the 12th, but I don't care if the 12 is a Saturday or not)
Many thanks for your help!
Best
New here, I'm struggling with a formal I wasn't able to find on the web.
I'm working for a hotel, and I would like to show if the bookings have a Saturday included or not.
Problem: the dates include the time..
I have the IN date:
and the OUT date:
I would need to show if those bookings include the night of Saturday in them, but I am struggling, could you help me please?
Ideally I would like to add a column at the end (let's name it: includes Saturday), and have an answer "Saturday", or just leave the cell blank if not.
Note: on this example, please take into account that the last night is the 11st (check out on the 12th, but I don't care if the 12 is a Saturday or not)
Many thanks for your help!
Best