Announcement

Collapse
No announcement yet.

Check If Cell is Not Empty & Less Than Today

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Check If Cell is Not Empty & Less Than Today

    I am trying to do write a formula to identify whether a date field is not null and less than today. My excel sheet appears as follows:

    Columns: A B c
    Task Due Date Status

    My condition is:

    - If Due Date in 'Column B' is not null and it is less than today, return 'true'

    I wrote the following formula for it:

    =(NOT(ISBLANK(B2)) AND (B2 < TODAY()))

    Excel shows error in the formula. I am not able to resolve it. Please help me to resolve it

  • #2
    Re: Formula For Identifying Whether Date Is Null And Less Than Today


    Try this formula. Array formulas will have curly brackets {} emcompassing the ENTIRE formula. You do not add these, you Enter the formula with Ctrl+Shift+Enter and Excel will add them (details: Array formulas). Many more Excel Formulas
     
     =and(not(isblank(b2)),b2<today()) 

    Comment


    • #3
      Re: Check If Cell is Not Empty &amp; Less Than Today

      Thank you, Dave. It worked.

      Comment

      Working...
      X