SUMIFS with Working Days



I have the following formula that works but I want to adjust it to working days only:

=SUMIFS({Column1}, {Date}, <TODAY(), {Date}, >TODAY(-90), {DE}, ([Column2]@row))

Is there a way to modify this formula to include only working days? I think that the sheet is counting weekends at this moment. I updated the properties of the sheet to specify Mon-Fri, but not sure how to implement "WORKDAY" into the formula. Can you please advise?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!