Creating a date/time formula that excludes weekends including friday

[whitey75]

I am currently trying to create a schedule in which the time/date fields exclude Friday, Saturday and Sunday. Cannot seem to get it to work properly and to continue throughout the spreadsheet. Sorry tried to copy and was hoping it would let you see my formulas.

[TABLE="width: 1606"]
<colgroup><col><col><col><col><col><col><col span="2"><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Machine[/TD]
[TD]SO#[/TD]
[TD]WO#[/TD]
[TD]Part #[/TD]
[TD]Qty Required[/TD]
[TD]Standard Casting Process Time[/TD]
[TD]Casting Start Date[/TD]
[TD]Casting End Date[/TD]
[TD]Curing/Conditioning Time[/TD]
[TD]Curing Start Time/Date[/TD]
[TD]Curing End Time/Date[/TD]
[TD]Needed in Machine Shop/Finishing by latest[/TD]
[TD]Machine Shop Process Time[/TD]
[TD]Finishing Days Required[/TD]
[TD][/TD]
[TD]Ship Date[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]SO#154611[/TD]
[TD]WO#192050[/TD]
[TD]F1003793551[/TD]
[TD]2[/TD]
[TD]1.0[/TD]
[TD]09/03/19 - 8:00 AM[/TD]
[TD]09/04/19 - 8:00 AM[/TD]
[TD]1.0[/TD]
[TD]09/05/19 - 8:00 AM[/TD]
[TD]09/06/19 - 8:00 AM[/TD]
[TD]9-04-19[/TD]
[TD]1.0[/TD]
[TD]1.0[/TD]
[TD][/TD]
[TD]9-06-19[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]SO#154605[/TD]
[TD]WO#192031[/TD]
[TD]F3M140080
40 X 80 X 1M[/TD]
[TD]1[/TD]
[TD]1.0[/TD]
[TD]09/04/19 - 8:00 AM[/TD]
[TD]09/05/19 - 8:00 AM[/TD]
[TD]3.0[/TD]
[TD]09/06/19 - 8:00 AM[/TD]
[TD]09/09/19 - 8:00 AM[/TD]
[TD]9-05-19[/TD]
[TD]0.0[/TD]
[TD]1.0[/TD]
[TD][/TD]
[TD]9-06-19[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]SO#154456[/TD]
[TD]WO#191823[/TD]
[TD]F100195316[/TD]
[TD]1[/TD]
[TD]1.0[/TD]
[TD]09/05/19 - 8:00 AM[/TD]
[TD]09/09/19 - 8:00 AM[/TD]
[TD]3.0[/TD]
[TD]09/09/19 - 8:00 AM[/TD]
[TD]09/12/19 - 8:00 AM[/TD]
[TD]9-19-19[/TD]
[TD]6.0[/TD]
[TD]2.0[/TD]
[TD][/TD]
[TD]9-27-19[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]SO#154434[/TD]
[TD]WO#191650[/TD]
[TD]F100537032[/TD]
[TD]1[/TD]
[TD]4.0[/TD]
[TD]09/09/19 - 8:00 AM[/TD]
[TD]09/16/19 - 8:00 AM[/TD]
[TD]0.0[/TD]
[TD]09/12/19 - 8:00 AM[/TD]
[TD]09/12/19 - 8:00 AM[/TD]
[TD]10-08-19[/TD]
[TD]1.0[/TD]
[TD]2.0[/TD]
[TD][/TD]
[TD]10-11-19[/TD]
[/TR]
</tbody>[/TABLE]

 

[Toadstool]

So which dates are given and which are you trying to calculate?

 

[Eric W]

Welcome to the Board.

I think you may need the WORKDAY.INTL function. If your date is in G2, you can use this function to go to the next day, excluding Friday, Saturday, Sunday:

=WORKDAY.INTL(G2,1,"0000111")

The 1's represent "weekend" days.

 

[whitey75]

So which dates are given and which are you trying to calculate?

I figured it out, but thanks for trying to help.

 

[whitey75]

I did exactly that, it was the start date that had me all confused. Thank you!

 

[Eric W]

Glad we could help.