Some time ago I turned to this group for assistance with an employee
scheduling problem. When the options were 10 days on and 4 days off
OR, 10-on, 1-off, 10-on, 8-off... The following formulae worked
briliantly.

=IF($G40,IF($F4="Reg 10-4",IF(MOD(G$1-
$G4,14)+1<=10,"on","off"),LOOKUP(MOD(G$1-$G4,29)+1,
{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,2 0,21,22,23,24,25,26,27,28;"on","on","on","on","on" ,"on","on","on","on","on","off","on","on","on","on ","on","on","on","on","on","on","off","off","off", "off","off","off","off"})),"")


I now have to contend with a new set of multiple schedule choices.
Given a fixed starting date, the calculation needs to generate a table
showing days worked and days off for the following scheduling types.

10-4
10-1-10-8
20-8
21-7
14-7


Not sure that a "formula" is still the best approach here, but thank
you in advance for any help all the same.

Scott