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.
You can use this formula below to convert it into a proper date:
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