please can you help,
I need a schedule that reflects a row at half hour (30 minutes) intervals and working-days only, for a period of three weeks. ie 48 columns per day. The first cell is outomaticaly retreafed from worksheet 1 and this first row of 48 columns is on worksheet 2.
formula in cell A1 is =INPUT!I27 and formula in cell B1 is =IF(WEEKDAY(F38,2) + 1 >5, F38+(7-WEEKDAY(F38,2)) + 1,G45F38 + 1) this formula in B1 must pls run at half-hour intervals.
thanking you in advance
By: Willem Mol