I have a formula that matches up the month, but not for the year.
A sale on 08-March-2016 will appear in March for both 2016 and 2017. I have highlighted the problem cell in red in the below image. Is there a way to include year?
example4.jpg
I have also attached the file I am using to try and figure this out.
Item.xls
Bookmarks