Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEADid some datetime parsing and lots of conditional formula (whether starting day and ending day falls on weekend or not) to plus/minus to get the exact number of weekdays.
A bit harder than I though it would be.
@SeanAdams Your solution really helped me build the intuitive sense to solve this solution, thanks for contributing.
My solution looks fairly similar to others however I didnt like how the table at the end wasnt sorted in date order so I did some extra work to address that.
Woah! My longest workflow so far!
Used the tip from https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Calculate-Business-Days-Between-Dat...