Working days of week & month

Hi,

Need a formula of working in a week considering month and holidays.

Excel file attached with all the details.

Pl. help.

Regards,
Nagesh.

Not sure if you only wanted work days for 1 week or for the whole month.
This formula gives you the whole month:

Please Login or Register  to view this content.

I mis-read your OP and was working on a formula to break down a month into it's weeks
As I was about to post it , I refreshed and saw nflsales formula and realised my mistake.
Since I did go that far anyway, I modified it to do what you asked, just so I could see if it worked against nflsales' fomula.
And it did....mostly....there were a few discrepancies and I'm not sure which ones right, so I thought I'd post it and let you work it out
Mine is far more complicated then nflsales so is more likely to be wrong I think...but I'll link it just incase.

As far as solution is concerned, Beamernsw's formula is working well. But I have to keep two columns for Week Start & Week end.

Since I have Week number (cell M1) and month number (Cell I1), if the formula can be linked to those cells, it will be easier.

As an example, pl. copy this formula (in the excel file), you may understand what I wanted.

=COUNTIFS($B$2:$B$366,"="&$I$1,$C$2:$C$366,"="&$M$1)-COUNTIFS($B$2:$B$366,"="&$I$1,$E$2:$E$366,"="&$M$1)

Pl. help.

Thanks,
nagesh.