Display only business days in date range formula?

In the worksheet below, I only want to show business days in order (M-F) and exclude the weekends. If I just copy down a formula that adds 1 to the previous day it will obviously show all the days.

Going further, I would like to only show a range of business days based on a given month. So if I entered in 7/1/13 in a cell for "July" it would list out all the business days from 7/1-7/31.


Excel Help.xlsx

Any help would be greatly appreciated!

Try

=WORKDAY(B$1,ROWS(A$1:A1)-1)

To be a little more complete...


IN A5 put
=WORKDAY(B1-1,1)

Then in A6 and filled down to around A30 put
=IF(A5="","",IF(MONTH(WORKDAY(A5,1))<>MONTH(A5),"",WORKDAY(A5,1)))

Nice! Thanks. Is there a way to get it to stop at the final business day of the month?

Originally Posted by 00pumpkin

Nice! Thanks. Is there a way to get it to stop at the final business day of the month?

Did you see my 2nd post ?

Just saw your next post. That will do it. Thanks!

You're welcome.