+ Reply to Thread
Results 1 to 6 of 6

Working days of week & month

  1. #1
    Forum Contributor
    Join Date
    02-15-2012
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2019
    Posts
    390

    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.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    12-28-2014
    Location
    NSW, Australia
    MS-Off Ver
    2016
    Posts
    563

    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. #3
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2013
    Posts
    8,638

    Re: Working days of week & month

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

    Say thanks to those who have helped you by clicking Add Reputation star.

  4. #4
    Valued Forum Contributor
    Join Date
    12-28-2014
    Location
    NSW, Australia
    MS-Off Ver
    2016
    Posts
    563

    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.
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    02-15-2012
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2019
    Posts
    390

    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. #6
    Valued Forum Contributor
    Join Date
    12-28-2014
    Location
    NSW, Australia
    MS-Off Ver
    2016
    Posts
    563

    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)
    Last edited by Beamernsw; 01-23-2016 at 03:43 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Working days passed & left in the month / week
    By nagesh.tvsr in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 01-13-2015, 07:56 AM
  2. Replies: 7
    Last Post: 01-28-2013, 12:20 PM
  3. Show days in a month dynamically + working days
    By vemix in forum Excel General
    Replies: 5
    Last Post: 12-28-2012, 07:54 AM
  4. [SOLVED] Function required to put each month days in to four week
    By Karnik in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-26-2012, 08:23 PM
  5. Previous working days date (Mon-Fri working week).
    By intothewild in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-22-2011, 01:00 PM
  6. How many week days in a month
    By llol_slim in forum Excel General
    Replies: 5
    Last Post: 02-08-2007, 09:01 AM
  7. [SOLVED] How can I add up lookups? Finding days in a week of a month
    By Michael at Thin Air in forum Excel General
    Replies: 5
    Last Post: 01-29-2006, 02:55 PM

Bookmarks

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