Results 1 to 6 of 6

Using "IF" and todays date

Threaded View

  1. #1
    Registered User
    Join Date
    05-22-2009
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    32

    Using "IF" and todays date

    Hi.

    I can't quite make this work.

    Basically I want to be able to return a result based on whether the date in a cell is in the past or not.

    So, Cell I5 will have a date in it. I need Cell J5 to return a result of "Closed" if the date is prior to today, or just return the date in Cell I5 if it is either today or in the future.

    I tried something like this: =IF(I5<TODAY(),"Closed") but I can't get it right

    Any suggestions?

    Cheers

    Andy
    Last edited by NBVC; 07-20-2010 at 11:49 AM.

Thread Information

Users Browsing this Thread

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

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