Autofill Numbers with weekdays only

Hi Stephen,

The WORKDAY function excludes weekends and also allows you to specify holidays that you want to exclude.

From the Function Browser:

The WORKDAY function returns the date/time value that is the given number of working days before or after a given date. Working days exclude weekends and any other specified dates.

Type the starting date into the "Workdays" table, cell B2

Formula in B3 =WORKDAY(B2,1,Holidays::B$2:B$4)

That calculates the next workday (adds 1 day to the cell above if it is not excluded as a weekend or holiday).

Regards,

Ian

Hi Stephen,

Weekdays only is easy:

Enter the first date in cell A2. Format the cell as Date and Time, and choose the format you want to display

Grab the Fill handle (small yellow circle that will appear when thepointer id brought near the bottom of cell A2) and drag it down to row 6. Numbers will insert the dates for Tuesday to Friday.

Click on cell A7 to select it, then type = to open the Formula Editor. Enter the formula shown in the editor, then click the green checkmark to confirm the formula and close the editor. ( The "7d" is read by Numbers as the duration value seven days.)

Grab the fill handle and drag down as many rows as you need weekday dates.

Optional:

Click the rference tab above column A to select the whole column.

Copy.

With the full column still selected, go to the Edit menu and choose Paste Formula results.

This replaces the formulas in column A with the last value they have calculated, leaving that fixed value in the cell.

With the dates in column A no longer dependent on the date six cells above them, it is now safe to delete the rows containing dates that are holidays. Or, you could leave them in, and make them 'red letter days' by selecting each holiday date and changing the text colour in that cell to red.

Regards,

Barry