How do I calculate # of days & the date in Excel?

I thought I could use the 'workday' formula to calculate what date a task would be finished but it doesn't seem to be working correctly. I want to be able to change the # of days and the dates change automatically. I don't want to include weekends.
NewMandrelTool.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.

als315Commented:
Can you show expected result?
0
Saqib Husain, SyedEngineerCommented:
It is working just fine. Are you sure you have the correct month?
0
als315Commented:
Look at this sample. May be you want something like it? You can also add holidays to your sheet and exclude them from working days
NewMandrelTool.xlsx
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
Exploring SharePoint 2016

Explore SharePoint 2016, the web-based, collaborative platform that integrates with Microsoft Office to provide intranets, secure document management, and collaboration so you can develop your online and offline capabilities.

MASEE Solution Guide - Technical Dept HeadCommented:
I tried teh same excel it works fine for me
EE.png
0
Marcia MorrisProject ManagerAuthor Commented:
als315... your example works but how do I add holiday's as I noticed 4th of July will happen during this time.
0
als315Commented:
Add sheet with holidays and add range as a last parameter to function. Look at sample
NewMandrelTool.xlsx
0
MASEE Solution Guide - Technical Dept HeadCommented:
@Marcia
Please make sure your date format also correct.
0
Saqib Husain, SyedEngineerCommented:
You can have a list of dates somewhere and include that range as a third argument

=WORKDAY($B$3,B9,A1:A5)

or include directly in the formula

=WORKDAY($B$3,B9,{"7/4/2015"})

Incidentally 4th of july 2015 is a Saturday.
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.