jneria
New Member
- Joined
- May 11, 2023
- Messages
- 7
- Office Version
- 365
- 2021
- 2019
- 2016
- Platform
- Windows
- MacOS
- Mobile
- Web
Hi all,
I am going crazy trying to figure this out. The formula I am using work for some dates but not others, please help me figure out what is wrong.
FIRST FORMULA:
=WORKDAY.INTL(D10, 21, "0000000", StatHolidays!A1:A24)+IF(WEEKDAY(WORKDAY.INTL(D10, 21, "0000000", StatHolidays!A1:A24),2)>5,2,0)+IF(COUNTIF(StatHolidays!A1:A24,WORKDAY.INTL(D10, 21, "0000000", StatHolidays!A1:A24))=1,1,0)
D10 = 2023-12-04
Result = 2023-12-27 (This is correct)
=WORKDAY.INTL(D26, 35, "0000000", StatHolidays!A1:A24)+IF(WEEKDAY(WORKDAY.INTL(D26, 35, "0000000", StatHolidays!A1:A24),2)>5,2,0)+IF(COUNTIF(StatHolidays!A1:A24,WORKDAY.INTL(D26, 35, "0000000", StatHolidays!A1:A24))=1,1,0)
D26 - 2023-05-16
Result = 2023-06-21 (This is incorrect, it should be 2023-06-20)
As you can see, I feel like I am using the exact same formulas, just editing the argument based on what I need. Please help and thank you.
I am going crazy trying to figure this out. The formula I am using work for some dates but not others, please help me figure out what is wrong.
FIRST FORMULA:
=WORKDAY.INTL(D10, 21, "0000000", StatHolidays!A1:A24)+IF(WEEKDAY(WORKDAY.INTL(D10, 21, "0000000", StatHolidays!A1:A24),2)>5,2,0)+IF(COUNTIF(StatHolidays!A1:A24,WORKDAY.INTL(D10, 21, "0000000", StatHolidays!A1:A24))=1,1,0)
D10 = 2023-12-04
Result = 2023-12-27 (This is correct)
=WORKDAY.INTL(D26, 35, "0000000", StatHolidays!A1:A24)+IF(WEEKDAY(WORKDAY.INTL(D26, 35, "0000000", StatHolidays!A1:A24),2)>5,2,0)+IF(COUNTIF(StatHolidays!A1:A24,WORKDAY.INTL(D26, 35, "0000000", StatHolidays!A1:A24))=1,1,0)
D26 - 2023-05-16
Result = 2023-06-21 (This is incorrect, it should be 2023-06-20)
As you can see, I feel like I am using the exact same formulas, just editing the argument based on what I need. Please help and thank you.