troubleshooting Question

get Date from file name

Avatar of Seamus2626
Seamus2626Flag for Ireland asked on
Microsoft Excel
14 Comments2 Solutions340 ViewsLast Modified:

I have a file name thats in this format

"DIV rec ddmmyyyy.xls"

I want a piece of formula to retrieve the date from this, so i can return ddmmyyyy

Join our community to see this answer!
Unlock 2 Answers and 14 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 14 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros