+ Reply to Thread
Results 1 to 4 of 4

Work Day of the following month

  1. 01-13-2021, 09:47 AM #1
    pauldaddyadams
    pauldaddyadams is offline
    Valued Forum Contributor
    Join Date
    04-21-2005
    Location
    Southern England
    MS-Off Ver
    Excel for Office 365
    Posts
    1,702

    Work Day of the following month

    Hi

    Can someone help me with a formula which I am struggling with which calculates the first work day of the following month.

    In my attached the yellow cells is where I would need the formula and i have included the expected result.

    I also need it to factor in bank holidays which I have listed also.

    Thank you!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 01-13-2021, 09:58 AM #2
    CK76
    CK76 is offline
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    MS365 Apps for enterprise
    Posts
    5,973

    Re: Work Day of the following month

    Try...
    =WORKDAY.INTL(EOMONTH(D5,0),1,1,myholidays)

    EDIT: FYI, you have 2020 as year in your holiday list.
    "Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something."
    ― Robert A. Heinlein
    Reply With QuoteRegister To Reply
  3. 01-13-2021, 10:05 AM #3
    pauldaddyadams
    pauldaddyadams is offline
    Valued Forum Contributor
    Join Date
    04-21-2005
    Location
    Southern England
    MS-Off Ver
    Excel for Office 365
    Posts
    1,702

    Re: Work Day of the following month

    Thank you CK76 - this worked!! Thanks for pointing out that I had 2020 listed, I havent mentally accepted we are in 2021 already lol
    Reply With QuoteRegister To Reply
  4. 01-13-2021, 10:07 AM #4
    CK76
    CK76 is offline
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    MS365 Apps for enterprise
    Posts
    5,973

    Re: Work Day of the following month

    You are welcome and thanks for the rep Here's hoping 2021 will be better than 2020.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Calculate work hours per month
    By 1Stacy in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-30-2016, 04:00 PM
  2. Measure Cut Off Time for work done in a month
    By hazel_max in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-23-2016, 10:35 PM
  3. [SOLVED] IF forumla to Work Out Maximum Number Hours People Can Work-If start/finish during a month
    By BDBJ1 in forum Excel General
    Replies: 5
    Last Post: 01-27-2016, 11:59 AM
  4. [SOLVED] Work Hours in Columns for Each Month
    By MICowboy13 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 06-12-2015, 10:57 AM
  5. [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
  6. Cannot get a month to date formula to work
    By TravisBennett in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-05-2013, 06:25 AM
  7. Formula to change work schedule from month to month
    By ibtrue in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-29-2010, 04:55 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1