+ Reply to Thread
Results 1 to 4 of 4

To return the date where the planned pcs is less than the capacity/day excluding Friday.

  1. #1
    Forum Contributor
    Join Date
    01-08-2012
    Location
    Saudi Arabia, Dammam
    MS-Off Ver
    MS Office LTSC Professional Plus 2021
    Posts
    113

    To return the date where the planned pcs is less than the capacity/day excluding Friday.

    HI,
    Good day.

    I'm trying to return the date where the planned pieces is less than the capacity/day excluding the Friday.
    Please find the attached excel file.
    Thanks for your support.

    Regards
    Muralidaran.
    Attached Files Attached Files
    Last edited by muralidaran; 08-24-2017 at 02:59 AM. Reason: SOLVED
    Thanks & Regards
    Muralidaran.

  2. #2
    Forum Contributor
    Join Date
    01-08-2012
    Location
    Saudi Arabia, Dammam
    MS-Off Ver
    MS Office LTSC Professional Plus 2021
    Posts
    113

    Re: To return the date where the planned pcs is less than the capacity/day excluding Frida

    Thanks, i have solved it with the below array formula.

    ={MIN(IF(((B5:O5<>B1)*(B6:O6<>"Fri"))>0,B7:O7))}

    Regards
    Muralidaran

  3. #3
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,136

    Re: To return the date where the planned pcs is less than the capacity/day excluding Frida

    Or,

    Try the following array formula in B2:

    =INDEX(B7:O7,MATCH(1,(B5:O5<B1)*(B5:O5<>0),0))

    confirmed by pressing CTRL+SHIFT+ENTER
    Attached Files Attached Files
    Last edited by cbatrody; 08-24-2017 at 03:33 AM.

  4. #4
    Forum Contributor
    Join Date
    01-08-2012
    Location
    Saudi Arabia, Dammam
    MS-Off Ver
    MS Office LTSC Professional Plus 2021
    Posts
    113

    Re: To return the date where the planned pcs is less than the capacity/day excluding Frida

    Thanks, that works fine.

+ 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] Formula to return first date where column planned is filled
    By Risto85 in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 08-23-2013, 03:07 AM
  2. [SOLVED] Count the days excluding Friday in every month using a date range.
    By miss_chloe in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-23-2013, 10:42 AM
  3. Replies: 2
    Last Post: 06-05-2013, 12:14 PM
  4. Replies: 9
    Last Post: 12-19-2012, 01:06 AM
  5. [SOLVED] Return a weekending date on a Friday
    By KiwiMyg in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-15-2012, 07:53 PM
  6. [SOLVED] Return a Date of the Following Friday
    By FranksView in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-31-2012, 01:02 AM
  7. Return Friday's Date - Of the Week Prior to selected date
    By JonesZoid in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-12-2012, 09:19 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