+ Reply to Thread
Results 1 to 5 of 5

Working Days based on month

  1. #1
    Valued Forum Contributor
    Join Date
    04-21-2005
    Location
    Southern England
    MS-Off Ver
    Excel for Office 365
    Posts
    1,678

    Working Days based on month

    Hi,

    I would like the ability to list reporting days based on a month. E.g. if I was to select the month August if would list the dates that would apply to workday -10 to work day +X (where X denotes the last working day of the month).

    On the attached spreadsheet on the tab “Work Day Calculator” I intend to state the month in D5. Where I need help is in the green cells to populate the date based on working days and holidays.

    I have provided sample data for August and September in columns G:M

    Can anyone help please?
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,025

    Re: Working Days based on month

    Try this formula in E8:

    =IF(WORKDAY($C$5,ROWS($E$7:E7)-11)>$E$5,"",WORKDAY($D$5,ROWS($E$7:E7)-11))

    Copy down.

  3. #3
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    2,925

    Re: Working Days based on month

    =WORKDAY.INTL($D$5,ROWS(C$8:C8)-11)
    Try this one
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

  4. #4
    Valued Forum Contributor
    Join Date
    04-21-2005
    Location
    Southern England
    MS-Off Ver
    Excel for Office 365
    Posts
    1,678

    Re: Working Days based on month

    Hi

    Is there anyway to include the holidays in also? e.g. in August the 8th and 29th are bank holidays.

  5. #5
    Valued Forum Contributor
    Join Date
    04-21-2005
    Location
    Southern England
    MS-Off Ver
    Excel for Office 365
    Posts
    1,678

    Re: Working Days based on month

    Solved it - just had to reference the holiday sheet! Thanks all for helping!

    Final formula: =WORKDAY.INTL($C$5,ROWS(C$8:C8)-11,,Holidays!$B$7:$B$19)

+ 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. Days of the month and week based on name month/year
    By RickMcc in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-01-2016, 03:22 PM
  2. formula to get number of working days in a month based on criteria
    By aravindhan_31 in forum Excel Formulas & Functions
    Replies: 21
    Last Post: 08-15-2016, 06:22 AM
  3. [SOLVED] Determine work days in current month or next month based on day of the month
    By sbrnard in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 05-29-2014, 05:14 PM
  4. List Working Days of the month
    By Suzette in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-13-2014, 02:04 PM
  5. Changing number of days in a month based on month chosen from a dropdown list.
    By st_judeu@yahoo.com in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 02-08-2013, 02:26 PM
  6. Show days in a month dynamically + working days
    By vemix in forum Excel General
    Replies: 5
    Last Post: 12-28-2012, 07:54 AM
  7. Number of Working Days in a month
    By Talbot in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-18-2008, 05:36 AM

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