Formula to calculate next 5 working days only

LisaB:-) · 10/15/19

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 · 10/15/19

Mary, take a look at the WORKDAY function.

LisaB:-) · 10/16/19

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 · 10/16/19

Try using +7

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

LisaB:-) · 10/17/19

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 · 10/17/19

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

Happy to help!

Formula to calculate next 5 working days only

Comments

Categories