Formula to calculate weekdays in multiple months

[cdmaningo]

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.

 

[bobsan42]

are you really sure you need a formula for this?
you may simply use the FillWeekdays functionality of Excel.
put in cell A1 the starting day that you need.
then select cell A1. grab the small black square at the bottom right of the selection rectangle but grab it with the RIGHT mouse button. While holding it - drag it across the worksheet as long as you like. When you release it a menu should appear -> select Fill Weekdays.
that's all there is to it if i got it right.

 

[Dave Patton]

Use Excel's built in Fill dates

Excel 2003

Put a start date in a cell
Select a range of cells
Edit | Fill | Series | Weekdays

 

[cdmaningo]

Thank you to both for such a quick response. This was too easy. Sorry, not so well versed on excel. I was going insane trying to figure this out.

Christina