I am new to stack overflow so my apologies if the format of this message is incorrect.
I honestly don't even know where to start on this. I was thinking a Vlookup with an if statement but I am very confused on how to approach this. Any help is greatly appreciated
=DATEVALUE(B5&1) will give you the first of the month in the current year
My suggestion is that you need to make your date format same in both places. better format is mmm-yy. because if you have months which exceeds current year then you will have problem. therefore always try to be specific about the date or months that always helps.
June-2022 is same is 01/06/2022 in my case, in your case 06/01/2022 because your computer date format is mm-dd-yyyy
You can use SUMPRODUCT OR INDEX AND MATCH