I replaced the 2nd part of the IF statement with a lookup for the 28
day time period and then either "ON" or "OFF" to indicate the day type.
I wasn't sure if yo urequired another 2 day period off after every 10
days or just the 1st 2 days off. You should be able to change the
formula to meet your needs.


=IF($G50,IF($F5="10-4",IF(MOD(AZ$3-$G5,14)+1<=10,"on","off"),LOOKUP(MOD(AZ$3-$G5,28)+1,{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16, 17,18,19,20,21,22,23,24,25,26,27,28;"on","on","on" ,"on","on","on","on","on","on","on","off","off","o n","on","on","on","on","on","on","on","on","off"," off","off","off","off","off","off"})),"")


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=186076

Excel Live Chat