Excel Date Conversion

[scohen819]

I've been trying all day to convert 2019-04-29T00:00:0004:00 to yyyy-MM-dd.

Can't seem to figure it out.  I had the formula once before, years ago, but no luck this time.  So frustrating.

Thanks!!!

[#2]

@scohen819 

Hi,

You can use this formula below to convert it into a proper date:

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

After that you can press Ctrl+1 to open the Format Cells dialog box, then go to Custom and use this custom format (yyyy/mm/dd), then hit OK.

Hope that helps