Microsoft Office Forums - View Single Post - Extracting date, month & year from a text string without using date format Help

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

View Single Post

Old

08-06-2021, 01:19 PM

Dominique Gascon Dominique Gascon is offline

Dominique Gascon is offline

Dominique Gascon uses Windows 10

Windows 10 Dominique Gascon uses Office 2019

Dominique Gascon uses Office 2019

Office 2019

Novice

Join Date: Jan 2021

Posts: 2

Dominique Gascon is on a distinguished road

Default

Simpler:
=YEAR(DATEVALUE(LEFT$A$1,FIND(",",$A$1)+5)))

And the same for day and Month

Attached Files

Copy of Extracting_Date_2simpler.xlsx (15.4 KB, 4 views)

Reply With Quote