Hi,
My sorce data date is May 2 2019 12:00AM and in a text format. I want to convert it to a date format of M/D/YYYY using a formula so that it reads 5/2/19. This formula must also work for double-digit days like May 13 2019 12:00AM will read 5/13/2019. I cannot change my source data so I need...