Add only working days in grid style using Microsoft Excel

1. Add a date in the first cell.

2. Click and drag the cell (horizontally in your case) from the bottom right corner to AutoFill it, for several cells.

3. When you release the mouse button, Excel fills the cells with calendar days but also displays an Auto Fill Options box.

4. Click the box and then select Fill Weekdays.

5. Excel removes any dates that fall in the weekend and only dates for weekdays will be displayed.

It can be done like this. Formulas in first row with data will be deferent than all the rest. Effect can be achieved by coping/pasting the second row. Rows can be skipped, but you need to be consistent with the number of rows skipped in one copping( gap between the rows needs to be fixed number).

B)

1. Use the first row to add labels of day (M, T, W, TH, F).
2. In cell A2 write the starting date (01/10/2018).
3. In cell B2 write the formula [@M]+1.
4. Drag the formula from cell B2 to cell E2.
   Formulas: B2=>[@M]+1, C2=>[@T]+1, D2=>[@W]+1, E2=>[@TH]+1.
5. In cell A3 write the formula A2+7.
6. From that point use block repeating from right to down until required.

The image depicts the procedure

One possible method using very simple formulas:

• Enter your starting date in the top-left cell (A1): 1/10/18.
• Enter the following formula in the cell next to it (B1): =A1+1.
• Copy B1 to C1, D1 and E1.
• Enter the following formula in the first cell on the next row (A2): =E1+3.
• Copy B1, C1, D1 and E1 to B2, C2, D2 and E2.
• Duplicate the newly completed row (2) as many times as desired.

Sample result: