• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

help me convert a weird text string to a date

A

alyarb

Platinum Member
This is the date format our backup server uses

2013/01/10 11:00PM


genius, i know.

anyway, i would like to first do a find and replace to get rid of the xx:xxPM or AM and get rid of the time. and from there, i know there will be some function like

=DATE(LEFT(H2,4),MID(H2,5,2),LEFT(H2,2))

but everything i've tried hasn't worked. i'm terrible with excel! what do you guys think?

thanks!
 
Assuming the format is static:

=DATE(LEFT(A1,4),MID(A1,6,2),MID(A1,9,2))

Stupid Excel starts counting letter positions from 1, not 0. 🙄
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top