இவற்றிற்கான களஞ்சியம் 'Excel' வகை

Sep 10 2006


CAPitalZ

Excel date format fix

Filed under Excel, Programming, Scripts

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))

No responses yet