Hello!
I can't wrap my head around the issue I face: I am trying to compute the correct end date based on the formula
=IF(OR(MOD(WEEKDAY(WORKDAY.INTL($C$2,$D$2,1,$B$2:$B$32)-1),7)=1,MOD(WEEKDAY(WORKDAY.INTL($C$2,$D$2,1,$B$2:$B$32)+1),7)<>0),WORKDAY.INTL($C$2,$D$2,1,$B$2:$B$32)+1,WORKDAY.INTL($C$2,$D$2,1,$B$2:$B$32)-1)
My start date is Wednesday July 26, 2017 , which is 42 942.
There are 7 working days, which means I have to add 9 (including two weekends) to 42 942, hence get 42 952.
I use the mod function to check if + 1 day gives Saturday, and as I show in the file, MOD(7,7)<>0 returns FALSE when the date + 1 is actually a Saturday.
How come? MOD(7,7) does equal 0; there is no remainder when we divide 7 by 7.
Please, help me to resolve this conundrum.
Thank you!
Bookmarks