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
Microsoft Excel
Last Comment
Saqib Husain
Can you show expected result?
It is working just fine. Are you sure you have the correct month?
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
@Marcia
Please make sure your date format also correct.
Please make sure your date format also correct.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.