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

Question

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 Answer

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