Formula to calculate next 5 working days only

LisaB:-)
LisaB:-) ✭✭
edited 12/09/19 in Smartsheet Basics

Hi everyone, I'd appreciate a bit of help here.

I have a checkbox which I need to populate with a formula that returns the next 5 days, but doesn't include weekends.

I'm currently using this, which is fine, but includes weekend dates.

=IF(AND(Start@row <= TODAY(+5), Finish@row >= TODAY()), 1)

Many thanks in advance.

Comments