Forum Discussion
colinjredmann
Feb 27, 2024Copper Contributor
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.
- Patrick2788Silver Contributor
- colinjredmannCopper Contributor
Patrick2788 That works! Thanks! Good to know some people know a lot more than me in excel.
- Patrick2788Silver ContributorYou're welcome!