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. 

LisaB:-)

Hi, I've looked at WORKDAY, but I can't see how to fit that into my IF statement.  

Also, I could be wrong, but it looks to me that WORKDAY returns a count of days, I don't want that.

Many thanks.

Paul Newcome

Try using +7

 

=IF(.........(Start@row <= TODAY(+7).....................)

LisaB:-)

Actually yes.  Because whenever you run the report, 7 days will include the weekends, but because there aren't any tasks, you just won't see them.  So it will effectively return 5 working days.

Thanks again Paul!

Paul Newcome

I was REALLY hoping there weren't any weekend tasks. Haha.

 

Happy to help!