Excel formula that excludes Sundays

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
Marcia MorrisProject ManagerAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

AlanConsultantCommented:
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.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Marcia MorrisProject ManagerAuthor Commented:
Hi Alan, I am getting a circular reference error using the formula you provided.
Circullar-Reference.PNG
0
Bill PrewCommented:
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
0
Marcia MorrisProject ManagerAuthor Commented:
Hi Bill, yes you're right. I need to change that back to values vs the formula that I have in there.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.