+ Reply to Thread
Results 1 to 2 of 2

Using Negative Dates

  1. #1
    Registered User
    Join Date
    06-14-2012
    Location
    Columbus, OH
    MS-Off Ver
    Excel 2007
    Posts
    2

    Using Negative Dates

    I need a formula to either display yes or no depending on whether a project with many different steps is on schedule to be completed on time. Each step has an individual due date, so essentially I need a formula that says whether or not today's date is before or after all of those dates. The other issue is that sometimes, there are blank cells for the due date column, and I'm having trouble using the ISBLANK( function.

    Here's what I have right now:
    =IF(OR(ISBLANK(C5:C20),C5:C20-TODAY()>0), "YES", "NO!")
    but it isn't working properly.

    Can anyone help?? Thanks!

  2. #2
    Forum Contributor
    Join Date
    08-22-2011
    Location
    Texas, United States
    MS-Off Ver
    Excel 2007 and 2010
    Posts
    516

    Re: Using Negative Dates

    Could you use

    =IF(OR(ISBLANK(C5),C5>TODAY()),"YES","NO")

    and copy this formula down all of the steps?
    Last edited by amotto11; 06-14-2012 at 03:54 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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