+ Reply to Thread
Results 1 to 2 of 2

Pulling dates between 2 dates

  1. #1
    Forum Contributor
    Join Date
    12-11-2009
    Location
    Toronto
    MS-Off Ver
    Excel 2010
    Posts
    517

    Pulling dates between 2 dates

    Hi all, im having a hard time trying to code where i want to pull dates from column H that are between todays date - 90 days and Todays date - 45 days.
    How can this vb code be written. this is what i have so far but not working

    Please Login or Register  to view this content.
    so basically 10/7/15 -90 days = 7/9/15
    10/7/15 -45 days =8/23/15

    So i want to pull dates from column H that are between 7/9/15 & 8/23/15

    Thanks

  2. #2
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,760

    Re: Pulling dates between 2 dates

    It's always best if you want a quick or any response to upload a workbook, otherwise you cause someone to have to create a workbook. Then what happens is it doesn't work in your workbook because of things that can't be predicted and you go back and forth trying to get it right. If you have sensitive data then change it, but make sure the structure, sheet names, date formatting etc. of the sample sheet reflects the actual workbook.
    Elaborate a little more on what you ultimately are trying to do. The term pulling dates doesn't help much.

    ViewPic
    Last edited by skywriter; 10-07-2015 at 02:26 PM.
    Click the * Add Reputation button in the lower left hand corner of this post to say thanks.

    Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.

+ 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. pulling multiple shipment dates
    By webber15 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 07-07-2015, 01:39 PM
  2. Pulling Data from Dates
    By mikaselm in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-07-2014, 11:25 AM
  3. [SOLVED] Pulling a Range of Dates and their Corresponding Values
    By SimbaStriker in forum Excel Formulas & Functions
    Replies: 34
    Last Post: 06-18-2014, 10:55 PM
  4. Pulling specific dates out of a list of dates
    By bohodgman in forum Excel General
    Replies: 3
    Last Post: 08-07-2013, 01:09 AM
  5. Pulling Multiple Dates from a Cell
    By clawinger in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-31-2012, 12:06 PM
  6. [SOLVED] Auto filling dates based on previously entered dates and averaging numbers if dates equal
    By grambograham in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-11-2012, 03:21 PM
  7. Help pulling data between two dates
    By Caidek in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-10-2011, 11:25 PM

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