Extracting date, month & year from a text string without using date format Help

		Microsoft Office Forums > Microsoft Excel > Excel
Extracting date, month & year from a text string without using date format Help

05-27-2021, 10:40 PM

xor

Windows 10 Extracting date, month & year from a text string without using date format Help

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,101

date =--MID(A1,FIND(" ",A1)+1,FIND(",",A1)-FIND(" ",A1)-1)
month =MID(A1,1,FIND(" ",A1)-1)
year =--MID(A1,FIND(",",A1)+2,4)

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Empty date cell shows wrong month & year	Learner7	Excel	3	06-16-2019 11:09 AM
Excel day date month year Function	greginky	Excel	1	01-05-2016 02:19 AM
How to calculate a rolling year-to-date percentage by quarter as the year progresses	sleake	Excel Programming	2	04-23-2015 11:51 AM
Excel 2013 – need help extracting date and time from text cell plus more.	Art Mann	Excel	1	07-18-2014 09:55 PM
Letter date changes when merging with Excel - not the format, the actual date!	Smallweed	Mail Merge	1	02-07-2014 06:00 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:05 AM.