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?
 
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
 
als315Commented:
Can you show expected result?
0
 
Saqib Husain, SyedEngineerCommented:
It is working just fine. Are you sure you have the correct month?
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
MAS (MVE)EE Solution GuideCommented:
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
 
MAS (MVE)EE Solution GuideCommented:
@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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.