Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- =IF(WEEKDAY(B3,2)>5,Input!$F$7,IF(COUNTIF(HOLIDAYS,DATE(YEAR(B3),MONTH(B3),DAY(B3)))>0,Input!$F$7,IF(AND(MONTH(B3)>=Input!$D$6,MONTH(B3)<=Input!$D$7,HOUR(B3)+1>=Input!$D$8,HOUR(B3)+1<=Input!$D$9),Input!$F$6,Input!$F$7)))
Add Comment
Please, Sign In to add comment
