Hi All
I'm having trouble with a formula, as you can see below, Row 3 (Starting at CM3) has a formula that calculates a 41 day on 14 day off roster and formats automatically, Formula below
=IF($A3="","",IF(CM$1>=$C3,VLOOKUP(MOD(CM$1-$C3,$A3+$B3),{0,"W";41,"O"},2),""))
What I am trying to do is add in Travel Days (T) at the start of the 41 days (W), end of the 41 Days and the end of the off days (O) - I have manually entered how I need it to look in Row 5
Is anyone able to assist with modifying the above formula
Hope there ins enough information, I can upload the spread sheet if needed
Regards
Steve
I'm having trouble with a formula, as you can see below, Row 3 (Starting at CM3) has a formula that calculates a 41 day on 14 day off roster and formats automatically, Formula below
=IF($A3="","",IF(CM$1>=$C3,VLOOKUP(MOD(CM$1-$C3,$A3+$B3),{0,"W";41,"O"},2),""))
What I am trying to do is add in Travel Days (T) at the start of the 41 days (W), end of the 41 Days and the end of the off days (O) - I have manually entered how I need it to look in Row 5
Is anyone able to assist with modifying the above formula
Hope there ins enough information, I can upload the spread sheet if needed
Regards
Steve