I'm using this formula which allows me to calculate the date in A5 based on the date i enter in A4:

=IF(WEEKDAY(A4)=7,A4+2,IF(WEEKDAY(A4)=6,A4+3,A4+1))

Then I can fill the series by clicking and dragging from A5 to the desired date and the column is filled with my dates, Mon through Fri, to whatever end date I want.

What I'd like to be able to do is put a start date in A4 and an end date in A5 and have it generate the same Mon through Fri list.

Any thoughts?

Thank You!