Ram Chandran
Member
Hi Guys,
I need a excel function for the below formula which can be apply in all Excel workbooks anytime.
=TEXT(DATE(LEFT(B2,4),MID(B2,5,2),RIGHT(B2,2)),"DD-MM-YYYY")
Thanks in advance
I need a excel function for the below formula which can be apply in all Excel workbooks anytime.
=TEXT(DATE(LEFT(B2,4),MID(B2,5,2),RIGHT(B2,2)),"DD-MM-YYYY")
Thanks in advance