We help IT Professionals succeed at work.

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

Bill Golden
Bill Golden asked
on
122 Views
Last Modified: 2017-10-27
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
Comment
Watch Question

Test your restores, not your backups...
CERTIFIED EXPERT
Expert of the Year 2019
Top Expert 2016
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
Bill GoldenExecutive Managing Member

Author

Commented:
Worked perfectly.  Thanks, Bill