# Working days of week & month

1. ## 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.

2. ## Re: Working days of week & month

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.``

3. ## Re: Working days of week & month

I5
``Please Login or Register  to view this content.``
Try this and copy towards down

4. ## Re: Working days of week & month

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.

5. ## Re: Working days of week & month

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.

6. ## Re: Working days of week & month

You can combine those formulas if you wish, but it will make a very long one

In I5:
``Please Login or Register  to view this content.``
Also, as a suggestion:
Cell C1: =WEEKNUM(A2,2)
Cell E2: =WEEKNUM(D2,2)

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1