my financial period runs from Oct to sept, where period 1= oct, 2 = Nov, 3 = Dec etc
I have extracted the period number from the file name as well as the year
I now need a formula to extract the month and year based on the period number and year extracted. I have manually extracted the Month & Year -see item in Yellow
I have attached sample data. The period in the example is 9 and the year is 2019, so I need June 2019 extracted in a date format
Your assistance in this regard is most appreciated
Bookmarks