In a world where everyday is Saturday or Sunday….
This formula works fine, but it’s overly complicated.
What I love about this example is how an initially complicated formula “collapses” into a simple solution.
Excel is full of hidden gems like this that can drastically simplify your work.
More formula info
