+ Reply to Thread
Results 1 to 8 of 8

List dates with three days to expire

  1. #1
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Talking List dates with three days to expire

    Hello
    I need to open excel, to be shown a list of dates that are 3 days to maturity.

    example:

    In column "E" I have several dates, when I open the file, you made ​​a calculation to see if the dates are three days to get the date iqual cell "D4".

    So I want vericas after the dates in column "E" is iqual cell "D4", a list box will appear with these dates.
    WARNING: You have to be for VBA, not conditional formatting!
    Can anyone help me.
    Cross-post
    http://www.thecodecage.com/forumz/mi...ys-expire.html

    Thank you!!
    Attached Files Attached Files
    Last edited by marreco; 03-02-2012 at 04:28 PM.

  2. #2
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Re: List dates with three days to expire

    Hi.

    Any ideia?
    Thank you!

  3. #3
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Re: List dates with three days to expire

    I know someone is going to help me.
    I'll be waiting Thanks

  4. #4
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: List dates with three days to expire

    Hi marreco
    You can try the attached...not certain it's what your looking for (can't seem to get it in Portuguese).
    Attached Files Attached Files
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

  5. #5
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Re: List dates with three days to expire

    I am very happy to have replied, thanks for replying!
    Jalaske, I need to appear the dates that are 3 days to maturity.

    You can make this change?
    Thank you very much!

  6. #6
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Re: List dates with three days to expire

    Let's leave it for now, should the need arise, peopl your help.

    For now thank you very much!!

  7. #7
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: List dates with three days to expire

    Hi marreco
    I was already looking at this before you marked your issue as SOLVED so here it is.
    Attached Files Attached Files

  8. #8
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Re: List dates with three days to expire

    Work great!!!

    Thank you!!!

+ 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