+ Reply to Thread
Results 1 to 2 of 2

Find correct Month and Year from list based on current date and add value to adjacent cell

  1. #1
    Registered User
    Join Date
    05-24-2012
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    5

    Find correct Month and Year from list based on current date and add value to adjacent cell

    Hello,

    I think that what I'm trying to do is very simple but I can't seem to wrap my head around it.

    I am looking for code that will search through Range A3:A62 for the month and year that matches the current date. Then I need to write "Matches" (or some other similar word) in Column AF of the row that the current date's month and year matches.

    For more information:
    My dates in column A are written as "1/1/2009" but are formatted to appear as "Jan-09". This is why I can't match the exact date - I am only looking at months and years.

    My list looks like:
    Jan-09
    Feb-09
    Mar-09
    ....
    Aug-12
    Sep-12

    So any day in August,2012 needs to match 8/1/2012 and any day in February, 2009 needs to match 2/1/2009, etc.


    Thank you very much in advance for you help!!

  2. #2
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675

    Re: Find correct Month and Year from list based on current date and add value to adjacent

    A simple formula should work, this formula will give the 1st of the current month

    =EOMONTH(TODAY(),-1)+1

    .....so in AF3 you could use this formula copied down

    =IF(A3=EOMONTH(TODAY(),-1)+1,"Matches","")
    Audere est facere

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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