To create a series of dates in a range, with just weekdays (Monday through Fridays), you first enter your starting date in a cell (B2, in the example below), and then enter the following formula in the cell below that cell.


Then use the Fill Down utility to fill out your entire series of dates.

The formula to display the day of the week we have already met…