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 or English word but not both
Anti-Spam Image

© 2022 - All Right Reserved. | Adadaa logo