+ Reply to Thread
Results 1 to 4 of 4

Calculate Number of Days if 3rd Cell has Closed

  1. #1
    Registered User
    Join Date
    10-13-2016
    Location
    Texas
    MS-Off Ver
    2010
    Posts
    17

    Calculate Number of Days if 3rd Cell has Closed

    I'm having problems getting the number of days if other cell has "Closed" in it.

    Start Date = G2

    End Date = H2

    Closed = F2

    What I need to do is only calculate the number of days if cell F2 has the word Closed in it. When cell F2 does not say closed it will say Open but I don't need the formula to look at that.

    Thank You
    Last edited by cdxjones; 04-07-2017 at 11:18 AM.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,838

    Re: Calculate Number of Days if 3rd Cell has Closed

    You mean like this?

    Excel 2016 (Windows) 32 bit
    G
    H
    I
    J
    2
    01/04/2017
    06/04/2017
    Closed
    5
    Sheet: Sheet1

    Excel 2016 (Windows) 32 bit
    J
    2
    =IF(I2="Closed",DATEDIF(G2,H2,"D"),"")
    Sheet: Sheet1
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    10-13-2016
    Location
    Texas
    MS-Off Ver
    2010
    Posts
    17

    Re: Calculate Number of Days if 3rd Cell has Closed

    That's it...

    Thank You

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,838

    Re: Calculate Number of Days if 3rd Cell has Closed

    You're welcome!

+ 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] calculate total number of days between two days based on 365 days year
    By aparunkumar in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 03-14-2016, 12:51 AM
  2. Replies: 0
    Last Post: 06-11-2015, 03:12 AM
  3. [SOLVED] Using sum product to show average number of days for closed work orders
    By mmccra2858 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-01-2014, 06:42 AM
  4. Calculate number of days between 2 dates & then assign a number based on the answer
    By MrHappyGoLucky12 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 03-27-2014, 09:20 PM
  5. Calculate number of closed tickets same day.
    By bandera in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-01-2013, 10:19 AM
  6. [SOLVED] Calculate the number days between two user input days.
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-21-2013, 10:44 PM
  7. [SOLVED] Calculate number of days between two days
    By hecgroups in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-03-2012, 11:28 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