Hello,
I'm trying to open the folder which matches with the cell 'B4' value.
Example if B4 is the date value 08/08/2019, I first would like to format 'B4' to "MM YYYY" format and compare that with the folder names and open the right match. In this case it should open 08 2019 folder.
Please advise
I'm trying to open the folder which matches with the cell 'B4' value.
Example if B4 is the date value 08/08/2019, I first would like to format 'B4' to "MM YYYY" format and compare that with the folder names and open the right match. In this case it should open 08 2019 folder.
Please advise