I am trying to list working days in a sheet, horizontally for a year as below:
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.
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.