Date Scheduling - Manufacturing Process

[Santhoshraj v]

While scheduling the dates for process wise operation, Start wise is next date of previous completion date.
In that situation i got a start date as Sunday (Weekend), in this i have used Workday formula for exception of weekend.
But Start date displays a date that falls on sunday, So i need to formula to sort out this and make as next working date as monday.

Formula attached.

 

[Toadstool]

Hi Santhoshraj v,

Try

=WORKDAY.INTL(WORKDAY.INTL(G113,-1,11),1,11)

 

[Santhoshraj v]

Hi Santhoshraj v,

Try

=WORKDAY.INTL(WORKDAY.INTL(G113,-1,11),1,11)

Hi, i'm getting same date of 19-02-2022, NOT NEXT WORKING DATE OF 19-02-2022 like (21-02-2022)

 

[Fluff]

How about

=WORKDAY.INTL(G113,1,11)

 

[Toadstool]

Assuming you want the next working day after 19-02-2022 and your only weekend day is a Sunday then:

Santhoshraj v.xlsx
	D	E	F	G
112
113				19-02-22
114	21-02-22
115
Sheet1

Cell Formulas
Range	Formula
D114	D114	=WORKDAY.INTL(WORKDAY.INTL(G113,-1,11),2,11)