Changing a formula to weekdays only

[RosieG1991]

Hey there

I'm working in a Gantt Chart (Timeline) and it has the formula:

=$D$5-WEEKDAY($D$5,1)+INDEX({1;2;3;4;5;6;7},MATCH($D$4,{"Sunday";"Monday";"Tuesday";"Wednesday";"Thursday";"Friday";"Saturday"},0))+D6


I would like to only see Monday - Friday (not weekends: Saturday/Sunday)

What changes do I need to make to the above formula to only see week days?

Any help is much appreciated!!!

 

[jorismoerings]

Hi,

If the formula is calculating the finish date of a task and assuming D4 and D5 are related (D4 = Wednesday, D5 = 08/02/17) and D6 is the number of days forward to finish the task.
Change the formula to this: =WORKDAY($D$5,D6)