Excel,  Programming,  Scripts

Excel date format fix

formula to reformat date from

Either set regional and language options to match the format

OR

DD/MM/YYYY to MM/DD/YYYY

OR
MM/DD/YYYY to DD/MM/YYYY

=(SUBSTITUTE(MID(C3,FIND(“/”,C3)+1,2),”/”,)&”/”&SUBSTITUTE(LEFT(C3,2),”/”,)&”/”&RIGHT(C3,4))

Leave a Reply

உங்கள் மின்னஞ்சல் வெளியிடப்பட மாட்டாது


To prove you're a person (not a spam script), type the security word shown in the picture.
You can enter the Tamil word
Anti-Spam Image