LinkBack URL
About LinkBacks
Luigi802 
For the date in A2:-
=INDEX({"On","On","Off","Off","On","On","Off","Off","Off","On","On","Off","Off","On"},(MOD(A2-DATEVALUE("4 Sep 2016"),14)+1))
Shifted rota in array once to right as first index will be 0 and last will be 13 (+1)
For the date in A2:-
=INDEX({"On","On","Off","Off","On","On","Off","Off","Off","On","On","Off","Off","On"},(MOD(A2-DATEVALUE("4 Sep 2016"),14)+1))
Shifted rota in array once to right as first index will be 0 and last will be 13 (+1)
Last edited by Neil_; 09-08-2016 at 02:19 AM.
Frob first, tweak later
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks