Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 3 of 3

Thread: Check If Cell is Not Empty & Less Than Today

  1. #1
    Join Date
    16th August 2007
    Posts
    2

    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

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,697

    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()) 


  3. #3
    Join Date
    16th August 2007
    Posts
    2

    Re: Check If Cell is Not Empty & Less Than Today

    Thank you, Dave. It worked.

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

  1. mecloran

Possible Answers

  1. Check if Cell Is Empty
    By vickyho1008 in forum EXCEL HELP
    Replies: 7
    Last Post: October 3rd, 2010, 05:06
  2. Before Paste Check Cell, If Not Empty Use Red
    By pilch in forum EXCEL HELP
    Replies: 2
    Last Post: June 27th, 2007, 02:02
  3. Check If Cell Is Empty Before XlUp
    By pike in forum EXCEL HELP
    Replies: 6
    Last Post: May 19th, 2007, 21:20
  4. Check Empty Cell
    By h in forum EXCEL HELP
    Replies: 3
    Last Post: February 21st, 2007, 05:08
  5. AutoFilter: Check if Cell Empty
    By Vargtass in forum EXCEL HELP
    Replies: 4
    Last Post: October 25th, 2006, 18:41

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
  •  
porno