Weekdays Mon-Thurs fill series

[falcios]

I have entered the following dates into cells that correspond to Monday-Thursday
9/10/18
9/11/18
9/12/18
9/13/18

I highlighted the cells and dragged to fill series so that it continues the pattern and it's not working.
I want to exclude Friday, Saturday, and Sunday dates.

How do I get this to work?

Thanks in advance.

 

[Eric W]

Put your first date (9/10/18) in A1, then put this formula in A2 and drag down:

=A1+IF(WEEKDAY(A1)=5,4,1)

 

[Rick Rothstein]

As far as I know, you cannot do a "skip pattern" like you want by manually dragging numerical/date constants. There is a formula method you can use though. Assuming your first date will be in cell A2 (I am assuming cell A1 will have header text in it), put the starting date in that cell, then put this formula in cell A3 and copy it down...

=WORKDAY.INTL(A2,1,"0000111")