•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
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]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com
#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#date extraction
#date format
#string manipulation
#Excel
#datetime formatting
#report generation
#year addition
#month and day
#timestamp extraction
#data entry
#line parsing
#coding solution
#function implementation
#recipient confirmation
#user query
#automating reports