# workday.intl

1. ### Subtract lunch break hours from Workday.Intl formula?

I need to calculate estimated completion date for various projects. However, I need to subtract lunch breaks, and Sundays so that the formula works correctly. The work continues 24 hours (from 00:00 to 24:00) with three lunch breaks (each 1 hour). Lunch breaks are 03:30 - 04:30; 11:30 - 12:30...
2. ### Workday returning a Saturday

Hi all, I thought I understood the Workday function, but apparently not. If my ref date is in B34 and holidays in lookup table, I thought this would return the first workday of the month: =WORKDAY.INTL(\$B\$34,1,1,'Unit Lookups'!\$A\$21:\$A\$33) For ref date 1/1/2022 it returns Monday 1/3/2022 as...
3. ### WORKDAY.INTL Need help with weekends data.

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...
4. ### Need last workday with Mon's & Tue's off

Hello all, I have this formula in B1 to find the last workday of the month having Mondays and Tuesdays off: =WORKDAY.INTL(A1,NETWORKDAYS.INTL(A1,EOMONTH(A1,0),3)-1,3) which goes down the column to B12, with A1:A12 varying from A1=01/01/2018 to A12=12/01/2018. It all works well except for Jan...

### 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.

### Which adblocker are you using?

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

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