Microsoft Office Forums - View Single Post - Macro or formula on Excel to Standardize dates

Thread: Macro or formula on Excel to Standardize dates

View Single Post

Old

02-13-2017, 05:32 PM

jeffreybrown jeffreybrown is offline

jeffreybrown is offline

jeffreybrown uses Windows Vista

Windows Vista jeffreybrown uses Office 2007

jeffreybrown uses Office 2007

Office 2007

Expert

Join Date: Apr 2016

Posts: 673

jeffreybrown has a spectacular aura about

jeffreybrown has a spectacular aura about

Default

You could use this to extract out the date

=TRIM(LEFT(A1,FIND(" ",A1)))+0

Reply With Quote