Link to home
Start Free TrialLog in
Avatar of Bill Golden
Bill GoldenFlag for United States of America

asked on

Putting the date and day in a cell based on filename and tab name

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
or
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.
DTL-EE-1711-Rev4.xlsm
ASKER CERTIFIED SOLUTION
Avatar of Bill Prew
Bill Prew

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Bill Golden

ASKER

Worked perfectly.  Thanks, Bill