I have a sheet with 2 different date formats
5/29/2009 9:00:02 AM
is it possible to create a formula that will remove the time stamp and change all dates to dd/mm/yyyy?
I got as far asthis works for type 1 but returns an error for type 2, I tried switching the DAY and MONTH in the formula but am still getting the error
Please Login or Register to view this content.