troy001100
New Member
- Joined
- Jan 21, 2019
- Messages
- 4
Hi.
I need some help with a formula, please.
see the below formula:
=IF(OR(J$13="",J$13<$Q$8,$A14=""),"",IF(NETWORKDAYS.INTL(J$13,J$13,weekend,holidays)=0,0,IFERROR(INDEX(daysoff_type,MATCH(J$13&" "&$A14,daysoff_lookup,0)),MID($B14,MOD(NETWORKDAYS.INTL($Q$8,J$13,weekend,holidays)-1,LEN($B14))+1,1))))
Pic1 - Starting Point
Pic2 - After I select Holidays only
I want to keep the red highlight
but I don't want to update it 0 and I don't want it to push the roster over by one day I want it to remain the same as pic1.
Any other advice would be fantastic
Many thanks
Troy
I need some help with a formula, please.
see the below formula:
=IF(OR(J$13="",J$13<$Q$8,$A14=""),"",IF(NETWORKDAYS.INTL(J$13,J$13,weekend,holidays)=0,0,IFERROR(INDEX(daysoff_type,MATCH(J$13&" "&$A14,daysoff_lookup,0)),MID($B14,MOD(NETWORKDAYS.INTL($Q$8,J$13,weekend,holidays)-1,LEN($B14))+1,1))))
Pic1 - Starting Point
Pic2 - After I select Holidays only
I want to keep the red highlight
but I don't want to update it 0 and I don't want it to push the roster over by one day I want it to remain the same as pic1.
Any other advice would be fantastic
Many thanks
Troy
