M T W T F M T

6/28 6/29 6/30 7/1 7/2 7/5 7/6 ......

Do you know a formula that I can use for this? I am trying to use a version of the formula below, however, I can only get it to work for 1 month.

Thank you!

Christina

Quote:

Originally Posted by Joe4

This is somewhat similar to IML, but it is a little different, so I will post it anyway.

Enter the first day of the month in A1, the in B1 enter this formula and copy down 23 times:

=IF(MONTH(WORKDAY($A$1-1,ROW()))=MONTH($A$1),WORKDAY($A$1-1,ROW()),"")

Note that I am making use of ROW(), which returns the current row number. It will also automatcially take care of the situation in which there are less than 23 workdays in a month.