Marcia Morris
asked on
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
NewMandrelTool.xlsx
Can you show expected result?
It is working just fine. Are you sure you have the correct month?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I tried teh same excel it works fine for me
EE.png
EE.png
ASKER
als315... your example works but how do I add holiday's as I noticed 4th of July will happen during this time.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
@Marcia
Please make sure your date format also correct.
Please make sure your date format also correct.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.