workday.intl

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

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

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

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