On Mar 10, 2:53*pm, joel wrote:
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,2*4,25,26,27,28;"on","on","on ","on","on","on","on","on","on","on","off","off"*, "on","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

Joel... You are a GOD!!!! Thank you very much for your help. It works
perfectly!

Scott