+ Reply to Thread
Results 1 to 5 of 5

Nested If Functions for Upcoming Expiration Dates and Expired Dates

  1. #1
    Registered User
    Join Date
    12-12-2017
    Location
    Tacoma, Washington
    MS-Off Ver
    Excel 16
    Posts
    6

    Nested If Functions for Upcoming Expiration Dates and Expired Dates

    Hello. I am trying to make a formula for work that I believe should be a nested IF function. I need the formula to tell me if the date is expired, if it is within 60 days of expiring, or if it is within 30 days of expiring. If it is further than 60 days to the expiration date, it should say something like good or valid. I am very new to excel and can't seem to figure out how to adapt an existing formula, though there are some that are close.

    I tried using =IF(B2-TODAY()<=0, "EXPIRED", IF(B2-TODAY()<=7, "PENDING EXPIRATION", "OK")) but it doesn't quite do what I need.

    Any help would be appreciated. Thanks.

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Nested If Functions for Upcoming Expiration Dates and Expired Dates

    Hi and welcome to the forum.

    Maybe
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    But if you find yourself nesting more than a handful of IFs you should consider other approaches since they just get a bit messy to read and debug.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    12-12-2017
    Location
    Tacoma, Washington
    MS-Off Ver
    Excel 16
    Posts
    6

    Re: Nested If Functions for Upcoming Expiration Dates and Expired Dates

    Richard, thank you, I will try this. I am more than willing to try other options, but I wouldn't even know where to start. If you have any suggestions, I am very open to trying them.

    Again, thank you.

    -Amber

  4. #4
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,598

    Re: Nested If Functions for Upcoming Expiration Dates and Expired Dates

    maybe:
    Please Login or Register  to view this content.
    Ben Van Johnson

  5. #5
    Registered User
    Join Date
    12-12-2017
    Location
    Tacoma, Washington
    MS-Off Ver
    Excel 16
    Posts
    6

    Re: Nested If Functions for Upcoming Expiration Dates and Expired Dates

    ProtonLeah, thank you for the reply. Your's works very well for what I need. I really appreciate it.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA to email on upcoming expiring dates
    By tflores626 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 10-19-2016, 09:40 AM
  2. VBA to email on upcoming expiring dates
    By tflores626 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-14-2016, 10:09 AM
  3. Replies: 7
    Last Post: 02-24-2016, 11:34 AM
  4. Replies: 12
    Last Post: 06-13-2014, 05:03 PM
  5. Replies: 11
    Last Post: 05-04-2014, 08:28 PM
  6. [SOLVED] Triple nesting if functions, dates - expiration
    By Tom King in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-21-2013, 11:56 AM
  7. Notification of upcoming dates
    By jlyons in forum Excel General
    Replies: 5
    Last Post: 06-17-2008, 02:06 PM

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