+ Reply to Thread
Results 1 to 2 of 2

Date Expiration formula PLEASE HELP!

  1. #1
    Registered User
    Join Date
    09-04-2019
    Location
    Austin, TX
    MS-Off Ver
    2016
    Posts
    6

    Date Expiration formula PLEASE HELP!

    Hi, I've been trying to figure this out for quite some time and its beyond me at this point. I've attached an example file below, thanks in advance!

    My challenge is the basically to take the information from the master sheet and filter it out through a lease expiration sheet. The criteria that the information needs to be filtered by is Column "H" and "I" (possibly "J", but thats only if you want an extra challenge/see if it makes any sense to include). The "H" column has one of two values, "Start" or "Expiration". Essentially, what I want my lease expiration sheet to do, is to be able to have a Combobox that has filtering options for 6 months to 24 months from todays date and then have the formula you help me create filter the information from the master sheet to populate my lease expiration sheet with the correct rows. If a row in the master sheet includes "start" in column H, then I want to have the option to add 3 years or 5 years to the start date. I understand that would create duplicate information, but that can be dismissed when we review. The "expiration" tag will be very easy to code as it either falls within the range or it doesn't. One of my issues is getting a circular reference error FYI so that might be something that happens to you as well. Some of my attempts are included on the lease expiration sheet in the columns right of the labels.

    Please hit me back with any questions if you're confused!

    Helpsheet.xlsx

  2. #2
    Forum Expert José Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: Date Expiration formula PLEASE HELP!

    Hi

    I suppose you can use the Advanced Filter to do this.
    Try Google to learn about 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. Adding Expiration Date and Days Left For Expiration Problem
    By Newmord in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-06-2018, 09:37 AM
  2. [SOLVED] Formula about expiration date according months?
    By momchil.vladov in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-17-2014, 09:14 AM
  3. [SOLVED] DATE EXPIRATION Formula
    By Reizor1989 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-28-2013, 04:34 PM
  4. Excel formula to figure out expiration date in the future
    By AQUANX4 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-05-2013, 09:05 AM
  5. Expiration Date Formula
    By waldronl in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-31-2013, 06:52 PM
  6. formula for expiration date invoice
    By clausule in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-01-2011, 02:48 PM
  7. Excel 2007 : Need a formula for calculating a Due/Expiration Date
    By Roderic McCullough in forum Excel General
    Replies: 1
    Last Post: 03-10-2011, 04:47 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