+ Reply to Thread
Results 1 to 5 of 5

Membership Expiration Notification

  1. #1
    Registered User
    Join Date
    02-06-2011
    Location
    Cleveland, Ohio
    MS-Off Ver
    Excel 2011
    Posts
    5

    Membership Expiration Notification

    I am trying to make a cell that if it is past the date in another cell (K2) then it will display the word "EXPIRED." BUT will display nothing if it has not reached that date or no date was entered. I'm having trouble with nested IF AND statements. Here is what I have:

    =IF(AND(K2<DATE, K2<>""),EXPIRED,"")

    The date in K2 is in X/X/X format. I'm stumped and rather inexperienced in Excel. Thanks!

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2504 Win 11
    Posts
    24,703

    Re: Membership Expiration Notification

    Is the term DATE representative of a range named cell or do believe it represents something else?
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    02-06-2011
    Location
    Cleveland, Ohio
    MS-Off Ver
    Excel 2011
    Posts
    5

    Re: Membership Expiration Notification

    I just thought it meant todays date in numeric form.

  4. #4
    Registered User
    Join Date
    02-06-2011
    Location
    Cleveland, Ohio
    MS-Off Ver
    Excel 2011
    Posts
    5

    Re: Membership Expiration Notification

    Ok so I think I got it confused, but my changes still aren't working

    =IF(OR(DATEVALUE(K2)<TODAY, K2<>""),EXPIRED,"")

  5. #5
    Valued Forum Contributor
    Join Date
    10-13-2010
    Location
    Sunderland, England
    MS-Off Ver
    Excel 2007 (Home) / 2003 (Work)
    Posts
    740

    Re: Membership Expiration Notification

    Assuming your expiry date is in cell A1:

    How about

    =if($K$2="","",if(A1<=$K$2,"Expired",""))

    However, if you just wanted to compare the date to today's date, you don't need to include K2 - intread you can simply use:

    =if(A1<=today(),"Expired","")

+ Reply to Thread

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