I have an Excel worksheet (attached) that I would like cell I30 to derive the date and day from part of the filename and the entire tabname.
For example, the attached filename is DTL-EE-1711-Rev3 with Tab named 02
I would like I30 to derive the year and month (1711) from the filename and the day (02) from the tabname.
AND print I30 something like
Thursday, November 2, 2017
November 2, 2017 - Thursday
or, if necessary
11-02-17 - Thursday
For internal security reasons, I would prefer this is done with VBA instead of an Excel formula.
Obviously, by the end of the month, there will be Tabs 01, 02, 03, 04 ... through 30 or 31 skipping Saturday and Sunday.