Forum Discussion

colinjredmann's avatar
colinjredmann
Copper Contributor
Feb 27, 2024
Solved

How to tell this formula to not include dates that are on weekends?

So I have the formula set up to take my arrival date and subtract 5 days from the arrival date. But I want the formula to not give me days that are on Saturday or Sunday.

I would like it to pretend like the weekend does not exist and keep counting backward.

 

In this example, I get a return date of 2/25/24, which is a Sunday. I would like it to say 2/23 instead. Hopefully that all makes sense.

 

Resources