•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Pulling in a date from a string when there is no year
Our take
If you're looking to extract dates from strings that lack a year, you're not alone. Many users encounter similar challenges when attempting to format dates from varied text entries. In your report, dates like "Friday, March 13 at 11:11 pm" need to be transformed into a standard format, such as "3/13/2026." This guide will help you navigate the process of parsing these strings and appending a specific year, empowering your data management and ensuring your reports are accurate and complete. Let's explore the solution together!
I have a report where the one column has rows that have the following verbiage:
Delivered on : Friday, March 13 at 11:11pm at Dock
Delivered on : Wednesday, March 25 at 1:13 pm to the Receiver
How do I extract it to say 3/13/2026. So adding in the year as well. I have been googling this and cannot seem to locate the answer :(
[link] [comments]
Read on the original site
Open the publisher's page for the full experience