Calculate if time difference between dates contains a specific day of the week

[csh8428]

I've seen a lot of posts on how to calculate the time between 2 dates(no prob there) and how to exclude weekends/holidays form the calc, but I haven't found one for quite what I'm looking how to do. 

I have 2 time-date fields. I'm trying to add a new True/False column that with a formula that calculates if the interval between those 2 dates contains a weekend day(Sat or Sun). I've tried various methods of converting the dates to days of the week and then to the numbered day of the week; and while the formulas work, I can't get the logic to work for all scenarios of that interval.

Thanks for any help!!

Craig

[afv2688 · Accepted solution]

Hello @csh8428,

I think this would do it:

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

[csh8428]

That worked.. Thanks!!