WORKDAY.INTL Need help with weekends data.

[elivergara]

I have the following problem with the table below: In column “F” I have a formula that takes the effective day and adds two business days to it. I am using the following formula: =WORKDAY.INTL(E2,2,1,H2:H17)
To see what is due today, I filter that column (“F”) to today.
The problem is, it works well most days, but:
Tuesdays it pulls Friday, Saturday and Sunday (which is correct), and then Wednesdays it gives me what was effective on Mondays,
The problem is, I need it to include Saturday and Sunday with Mondays, and show it on Wednesday's data (anything ordered over the weekend should be due two days after).

	A​	B​	C​	D​	E​	F​
1	Patient Name	Patient Number	Location	Meds Ordered date	Meds Effective	Meds Due
2	Doe, John	12345	West Hall	1/22/2020​	1/26/2020​	1/28/2020​
3	Doe, Jane	56789	Triaging	1/22/2020​	1/26/2020​	1/28/2020​

Is it possible to do that?
Thanks!

 

[Toadstool]

Hi Elivergara,

WORKDAY.INTL lets you specify non-working days with a string of 0 and 1 starting with Monday, so if you want Saturday, Sunday and Monday to be non-working days you can use:
=WORKDAY.INTL(E2,2,"1000011")
(I omitted the Holiday table as you don't show it in your post).

I don't think that's actually what you want but I'm having difficulty following your post so more example dates with the expected result would help.