+ Reply to Thread
Results 1 to 4 of 4

If statements with dates and blank cells

  1. #1
    Forum Contributor
    Join Date
    03-20-2013
    Location
    Toronto
    MS-Off Ver
    Excel 2010
    Posts
    108

    If statements with dates and blank cells

    Hi,

    I have a table with columns for Due Date, Completion Date, and Status. In the Status column I have the formula =IF([@[Completion Date]]<=[@[Due Date]], "On-Time", "Late").

    But if the Completion Date is blank, the Status column returns a "on-Time" value. How to do I get it to return a blank value?

    Your help is appreciated. Thank you

    Rowena
    Last edited by rowena229; 10-23-2019 at 03:00 PM.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: If statements with dates and blank cells

    Try this instead:

    =IF([@[Completion Date]]="","",IF([@[Completion Date]]<=[@[Due Date]], "On-Time", "Late"))

    Hope this helps.

    Pete

  3. #3
    Forum Contributor
    Join Date
    03-20-2013
    Location
    Toronto
    MS-Off Ver
    Excel 2010
    Posts
    108

    Re: If statements with dates and blank cells

    Yes it worked Thank you

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: If statements with dates and blank cells

    You're welcome - thanks for the rep.

    Pete

+ 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] Nested IF Statements with Blank Cells
    By 8krungirl in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-09-2018, 03:43 PM
  2. [SOLVED] Multiple If Statements if Cells are Blank
    By SlimPickens in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-04-2017, 12:22 PM
  3. [SOLVED] If Statements and blank cells
    By Nick2512 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-09-2017, 11:35 AM
  4. [SOLVED] If dates are blank then in that date row all rightside cells should be blank.
    By Sekars in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 04-04-2016, 03:19 PM
  5. IF Statements, Dates, %, and Blank Cells
    By Karenh119 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-03-2015, 04:00 PM
  6. [SOLVED] COUNTIF and IF statements to count non-blank cells only
    By rowena229 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-25-2015, 01:57 PM
  7. Dates with IF statements and blank cell
    By GrayGhost in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-02-2013, 05:36 PM

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