Extracting the Date in the Sheet Tab

[KamenRider]

Hi,

The excel filename Progress_IPO has a sheet name Progress_IPO.01-31-2022. May I ask what formula should I use to extract the date and add it as part of the filename. I would like to create another file (duplicating it) by saving it on the different shared drive with filename "Progress_IPO.01-31-2022" with same name as the sheet name.

I hope you could assist me on this matter.

Thanks,

Mar

[PhilipMannering]

Hi @KamenRider 

You'll have to modify it to use your directories and filepaths, but something like this should work (see attached)