+ Reply to Thread
Results 1 to 7 of 7

Difference Between Dates in Days When One Date is Blank

  1. #1
    Registered User
    Join Date
    07-21-2014
    Location
    Atlanta, GA
    MS-Off Ver
    MS Excel 365
    Posts
    19

    Question Difference Between Dates in Days When One Date is Blank

    I want to show how many days it takes to resolve an issue. I want the result to display in Days. However when the Resolved Date is blank, I want the result "Aging" to show how many days from "Opened" to Today so it will show how many days it has remained unresolved. Sample attached.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    office 365 for MAC
    Posts
    3,105

    Re: Difference Between Dates in Days When One Date is Blank

    I think you have the answer in C2, you need to drag it down....

  3. #3
    Registered User
    Join Date
    07-21-2014
    Location
    Atlanta, GA
    MS-Off Ver
    MS Excel 365
    Posts
    19

    Re: Difference Between Dates in Days When One Date is Blank

    I am an idiot! Thanks! The weird thing is, when I had in the larger table and dragged it down, there were still blanks. But now that I am doing what you said in the smaller sample, it works. Go figure! Thank you

  4. #4
    Registered User
    Join Date
    07-21-2014
    Location
    Atlanta, GA
    MS-Off Ver
    MS Excel 365
    Posts
    19

    Re: Difference Between Dates in Days When One Date is Blank

    How do I show the result in Days...meaning how can I add the word days to the result?

  5. #5
    Forum Expert
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    office 365 for MAC
    Posts
    3,105

    Re: Difference Between Dates in Days When One Date is Blank

    No problem.
    Add &" days" at the end of the formula

  6. #6
    Registered User
    Join Date
    07-21-2014
    Location
    Atlanta, GA
    MS-Off Ver
    MS Excel 365
    Posts
    19

    Re: Difference Between Dates in Days When One Date is Blank

    Thanks! It is coming back with many numbers past the decimal point and would not allow me to change the format. So I will just change the result header to "Aging in Days" and be done with it.

  7. #7
    Forum Expert
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    office 365 for MAC
    Posts
    3,105

    Re: Difference Between Dates in Days When One Date is Blank

    You're right, sorry
    Try this:
    =TEXT(IF(B2="",TODAY()-(A2),B2-A2),0)&" days"

+ 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] Need to calculate # of days per month between two dates even if end date is blank
    By jimthe5th in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 02-09-2023, 01:31 AM
  2. Fill series of dates with a difference of days upto a specific date
    By green369 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-28-2017, 06:07 AM
  3. Replies: 6
    Last Post: 09-12-2014, 02:03 PM
  4. [SOLVED] Days between dates, blank if one or both columns have no date
    By Jettero2112 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-05-2014, 08:24 AM
  5. Replies: 8
    Last Post: 02-08-2013, 04:29 AM
  6. difference between dates in no. of days
    By JAYLOTT in forum Excel General
    Replies: 4
    Last Post: 06-07-2007, 04:53 AM
  7. [SOLVED] Number of days between 2 dates, if end date is blank assume todays
    By JulesM in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 03-01-2006, 08:45 AM

Tags for this Thread

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