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!!
Bookmarks