WORKDAY.INTL Need help with weekends data.

elivergara

New Member
Joined
Mar 23, 2015
Messages
13
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​
1Patient NamePatient NumberLocationMeds Ordered dateMeds EffectiveMeds Due
2Doe, John12345West Hall
1/22/2020​
1/26/2020​
1/28/2020
3Doe, Jane56789Triaging
1/22/2020​
1/26/2020​
1/28/2020

Is it possible to do that?
Thanks!
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

Toadstool

Well-known Member
Joined
Mar 5, 2018
Messages
2,194
Office Version
  1. 2016
Platform
  1. Windows
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.
 

Forum statistics

Threads
1,148,108
Messages
5,744,876
Members
423,907
Latest member
zerocool88

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top