Add text based on date in another cell

[MHamid]

Hello,

I was wondering if this was possible to do in vba code.

I have a date in cell A15 and A16 ... 3/31/18 and 2/28/18 respectively. In the cells next to the date I need text that will pull the year and then some instr text or it can all be instr. I'm looking to type a file name like "2018_AA_BBBB_2018_04_17_V1.1_(Mar_Final).xlsm". The important information in the file name is the year, which I'd like to be pulled from the dates in A15 and A16, and the words "(Mar_Final).xlsm". Year, dates, and versions will vary.

Column A Column B
3/31/2018 2018_AA_BBBB_2018_04_17_V1.1_(Mar_Final).xlsm
2/28/2018 2018_AA_BBBB_2018_03_13_V1.2_(Feb_Final).xlsm

My goal is to be able to pull particular data from these files. So I just thought that it would be easier to have the file name (even if it's not exact and just an instr function) and then some kind of code that will open the file name in that cell and then do a vlookup to bring back the data that is needed.

Is this possible?

Thank you