+ Reply to Thread
Results 1 to 4 of 4

how to get Next working day formula with if function?

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    02-10-2016
    Location
    Karachi, Pakistan
    MS-Off Ver
    2016
    Posts
    173

    how to get Next working day formula with if function?

    Hi Guys!

    I am developing a work plan of field officer in which they select month and than cells will auto generate dates (with working days)

    i am using this formula in B4 to get first working day
    Formula: copy to clipboard
    =WORKDAY(EOMONTH(A1,-1), 1)
    this works perfect but now we want that field office will re-visit after 5 days but it is difficult to get working day after 5 days in a specific cell.

    i am using this formula to add 5 days
    Formula: copy to clipboard
    =B4+5
    this is good but it showing Sundays also.

    Hope you guys understand

    sorry i can not upload sample because of our Office IT restriction.

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: how to get Next working day formula with if function?

    Perhaps

    Formula: copy to clipboard
    =B4+IF(WEEKDAY(B4+5)=1,6,5)
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Contributor
    Join Date
    02-10-2016
    Location
    Karachi, Pakistan
    MS-Off Ver
    2016
    Posts
    173

    Re: how to get Next working day formula with if function?

    you are really genius
    Last edited by Imran Magsi; 09-09-2016 at 05:37 AM.

  4. #4
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2024
    Posts
    6,178

    Re: how to get Next working day formula with if function?

    Or ...

    =WORKDAY.INTL(B4,5,11)

+ 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. Replies: 8
    Last Post: 01-04-2016, 05:46 AM
  2. Formula is not working - need indirect function?
    By lexusap in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-23-2015, 06:36 PM
  3. [SOLVED] Excel date function with formula not working
    By mark888 in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 01-17-2015, 02:09 PM
  4. Problem: HLOOKUP function as an array formula not working!
    By TomU in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 03-10-2014, 03:04 AM
  5. HELP - Multiple IF Function Formula not working
    By HamaTime in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-18-2013, 09:27 PM
  6. Replies: 14
    Last Post: 10-25-2012, 10:33 AM
  7. Replies: 1
    Last Post: 09-30-2005, 09:05 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