+ Reply to Thread
Results 1 to 3 of 3

IF statement to get data for date expiry

  1. #1
    Registered User
    Join Date
    05-12-2016
    Location
    Mumbai, India
    MS-Off Ver
    2010
    Posts
    56

    Exclamation IF statement to get data for date expiry

    Hi,

    I am trying to have 3 options: 1) Renewal Pending, 2) Valid, 3) Expired

    Renewal pending should be considered only when the "Agreement Due Date" is under 30 days of today's date
    Expired should be considered if the "Agreement Due Date" has passed
    Else it should consider valid

    I have tried different formulas but it is not working.

    Have attached the sheet with my calculations. Please help.
    Attached Files Attached Files

  2. #2
    Forum Expert leelnich's Avatar
    Join Date
    03-20-2017
    Location
    Delaware, USA
    MS-Off Ver
    '97, 2016
    Posts
    2,523

    Re: IF statement to get data for date expiry

    Perhaps this (in F7):
    =IF([@[Agreement Due Date]]="", "",IF([@[Agreement Due Date]]< TODAY(),"Expired",IF([@[Agreement Due Date]]-TODAY() <=30,"Pending", "Valid")))

    Please click the Add Reputation star below any helpful posts, and if you have your answer, mark your thread as SOLVED (Thread Tools up top). Thanks!-Lee

  3. #3
    Forum Expert leelnich's Avatar
    Join Date
    03-20-2017
    Location
    Delaware, USA
    MS-Off Ver
    '97, 2016
    Posts
    2,523

    Re: IF statement to get data for date expiry

    Thank you for the rep, happy to help! If you have your answer, please go to Thread Tools up top and mark your thread as SOLVED. - Lee

+ 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. How to create a date of manufacture and expiry date from a batch number
    By misterzim in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 10-23-2018, 05:24 AM
  2. [SOLVED] Count days before expiry date & after Expiry date in one formula
    By Macfool in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-16-2017, 02:58 PM
  3. autocalculate expiry date / expiry date colour warnings
    By kimbling1 in forum Excel General
    Replies: 8
    Last Post: 08-27-2014, 02:53 AM
  4. Replies: 0
    Last Post: 06-28-2014, 09:31 AM
  5. Data extraction from one sheet to another sheet by expiry date
    By binoos123 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-24-2014, 02:12 PM
  6. [SOLVED] Allocating a given date to a date range bucket: futures contract expiry
    By labogola in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-26-2013, 08:50 AM
  7. If statement for expiry dates
    By mfairhurst1 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-22-2013, 06:19 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