ortmll
New Member
- Joined
- Dec 15, 2014
- Messages
- 3
I need to update my formula so that it captures the month & year of a date.
Here is what I have now: =IFERROR(VLOOKUP(MONTH(D8),Months,2),"")
It works perfectly when all of the months are in the same year, but since the new year it is unable to differentiate between 2014 & 2015.
My gut tells me this is an easy fix, but my brain has thus far been unable to deliver.
<TBODY>
</TBODY>
Here is what I have now: =IFERROR(VLOOKUP(MONTH(D8),Months,2),"")
It works perfectly when all of the months are in the same year, but since the new year it is unable to differentiate between 2014 & 2015.
My gut tells me this is an easy fix, but my brain has thus far been unable to deliver.
- D8 represents the cell containing my date.
- "Months" represents my table containing the months of the year
- I added the column containing the years to expand this formula, but so far it has not worked
<TBODY> </TBODY> | |
<TBODY>
</TBODY>