show if Saturday in date range with time

[Sebas_]

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

 

[Sebas_]

Ah ok i didnt think of the times..

=IF(MAX(0,NETWORKDAYS.INTL(A1,B1-(WEEKDAY(B1)=7),"0000010"))<>INT(B1)-(WEEKDAY(B1)=7)-INT(A1)+1,"Saturday","No Saturday")

Yes!! This one works fine! Thanks a lot, I would never have been able to fin that myself! Greatly appreciated!

Greatly "abusing" your knowlegde, would you have a formula to find if there is a public holiday? I did create a list and have no problem finding the number of working days in between 2 dates (used for calculating paid holidays for example), but I am a bit stuck in my process to have the same behavior: is there a public holiday in this date interval? (with once again checkin date incluse holidays but checkout not including them)?

Thanks a million, you really made my (confided) day!

 

[Sebas_]

(retyping my reply as my previous post didn't work)

Ah ok i didnt think of the times..

=IF(MAX(0,NETWORKDAYS.INTL(A1,B1-(WEEKDAY(B1)=7),"0000010"))<>INT(B1)-(WEEKDAY(B1)=7)-INT(A1)+1,"Saturday","No Saturday")

This work!! Thanks a million!!
I would definilty not have been able to come up with such a formula by myself, your help is truly appreciated! You really made my (confined) day!

Would you mind if I "abuse" your kindness a bit more? I would also like to find if there is any public holidays in the date range. I already have a list of public holidays in Colombia (we use it to track holidays of the staff), but I' m unable to find if there are some in the range of the bookings (same as before: checkin date counts, but no check out date). Thanks a million, you would be rewarded by my eternal gratitude!

Best