|Mike is correct is asking for details about your data layout, but just for fun I tried something and it might work for you.|
Assuming your data looks like this, use the formula shown in B3 and drag it down. If your "Items" start in a different Row, you will have to change the ROW()-2 part of the formula to whatever works for you.
The date in Column B should change every 27 items and skip Saturday and Sunday dates.
1 Item #/Name Date
2 1/Name 1 12/30/13
3 2/Name 2 =IF(MOD(ROW()-2,27)=0,WORKDAY(B2,1),B2)
4 3/Name 3 =IF(MOD(ROW()-2,27)=0,WORKDAY(B3,1),B3)
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.
message edited by DerbyDad03