+ Reply to Thread
Results 1 to 2 of 2

Lookup only Month and Year in full date

  1. #1
    Registered User
    Join Date
    10-30-2014
    Location
    united states
    MS-Off Ver
    2010
    Posts
    11

    Lookup only Month and Year in full date

    I have a spreadsheet full of dates and times. I'd like to extract certain data based on just the month and year for a monthly website report but everything I'm finding and trying doesn't seem to work properly.

    Here's an example:

    A B C
    1 Date Views Clicks
    2 January 1, 2017 9:50 PM 1,000 50
    3 January 3, 2017 11:05 AM 2,035 102
    4 January 15, 2017 12:06 PM 503 12
    5 February 17, 2017 10:03 AM 704 34
    6 February 23, 2017 8:56 AM 980 25

    I'd like something where I could enter in a specific month and year (let's say February 2017) and it will return only data for that month.

    If date = February 2017 (any day) return values:

    February 17, 2017 10:03 AM 704 34
    February 23, 2017 8:56 AM 980 25

    I'd prefer something I could easily update each month...for example if cell D1 contained the lookup date and was changed from February 2017 to January 2017, it would update to show the first 3 rows in the table containing January data instead of the last 2 which are February. I can't seem to find anything that won't give me empty rows or where the formula itself needs to be updated each month (other people are using this, so I need to make it as easy to use as possible.)

    Thanks for the help!

  2. #2
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Lookup only Month and Year in full date

    maybe autofilter?
    Attached Files Attached Files

+ 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. [SOLVED] Lookup for the current month and year value by the today date.
    By thilag in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-31-2014, 03:07 AM
  2. Need to convert Month/Date/Year to Year/Month/Date so excel will recognize
    By juliettelam in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-25-2014, 04:17 PM
  3. [SOLVED] Date function- 1st day of month for 2nd full month from start date
    By vidiotdave in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-25-2014, 05:33 AM
  4. Replies: 3
    Last Post: 09-04-2013, 10:49 AM
  5. [SOLVED] Create Fiscal Year - Lookup Date in Fiscal Month Date Range and Return EOM Date
    By gbriscoe in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-25-2013, 03:29 PM
  6. Duplicate date 3 times for a full year in one column
    By puchimo in forum Excel General
    Replies: 5
    Last Post: 11-14-2012, 08:46 PM
  7. Replies: 0
    Last Post: 10-23-2012, 11:44 AM

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