i have a sheet of excel with date in the format dd/mm/yy i want to convert to mm/dd/yy
i did that with the formula text(a1,"mm/dd/yyyy"). and dates below 12 got converted however dates above 13 and 13 are not changing as per desired format can somebody please guide me to get the formula for dates =13 and above 13
i did that with the formula text(a1,"mm/dd/yyyy"). and dates below 12 got converted however dates above 13 and 13 are not changing as per desired format can somebody please guide me to get the formula for dates =13 and above 13