How to combine an IF statement with Workday and MAX functions
I'm currently using the MAX function to determine the "Next Maintenance" date based on the "follow-up" columns as shown below. I'm looking for a way that if its output has a date of a weekend, it would automatically populate the next Monday date. As an example below, the next maintenance date coming from the MAX formula would be a weekend, and my goal is for it to directly have an output of August 23rd instead of 21st. Is it possible to add here an if statement with both Workday and MAX functions to serve the purpose or is there other ways of doing this?
Help Article Resources
Check out the Formula Handbook template!