Formula to calculate next 5 working days only

LisaB:-)

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.

Andrew Gross

Mary, take a look at the WORKDAY function.