Excel formula that excludes Sundays

Marcia Morris
Marcia Morris used Ask the Experts™
on
Would like to use a formula that takes the date in cell A4 and add the # of days in H2 which provides a date in cell H4 BUT I want the formula to include Saturdays and exclude Sunday's in it's calculation.
Avio-LPT-Case-Waterfall-MASTER_MM_V.xlsx
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Consultant
Commented:
Hi,

Try this in H4:

=WORKDAY.INTL($A4,H$1,11)

I am guessing you meant 'number of days in H1' rather than 'number of days in H2'?

This finds the date H1 workdays from A4, counting only Sundays as a weekend day (the 'weekend argument' is 11).

See here for more info:
https://support.office.com/en-us/article/workday-intl-function-a378391c-9ba7-4678-8a39-39611a9bf81d

Thanks,

Alan.
Marcia MorrisSr. Project Manager

Author

Commented:
Hi Alan, I am getting a circular reference error using the formula you provided.
Circullar-Reference.PNG
Bill PrewIT / Software Engineering Consultant
Top Expert 2016

Commented:
The circular reference is being caused by A4 containing the formula "=H4".  Shouldn't that be an actual date, not a reference to H4?


»bp
Marcia MorrisSr. Project Manager

Author

Commented:
Hi Bill, yes you're right. I need to change that back to values vs the formula that I have in there.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial