Naresh Yadav
Active Member
Respected All,
I have Data of Date which is stored in text and number format
I am trying to get the result in "DD-MMM-YYYY" format through TEXT Formula
But not getting my expected result
Kindly find attached excel file and suggest a formula that can help me to come out from it
activity_date Result Using Text Function Expected Result
12-01-2017 12-Jan-2017 01-Dec-17
12-02-2017 12-Feb-2017 02-Dec-17
12-04-2017 12-Apr-2017 04-Dec-17
12/13/17 12/13/17 13-Dec-17
12/13/17 12/13/17 13-Dec-17
12/14/17 12/14/17 14-Dec-17
12/15/17 12/15/17 15-Dec-17
regards
Naresh
I have Data of Date which is stored in text and number format
I am trying to get the result in "DD-MMM-YYYY" format through TEXT Formula
But not getting my expected result
Kindly find attached excel file and suggest a formula that can help me to come out from it
activity_date Result Using Text Function Expected Result
12-01-2017 12-Jan-2017 01-Dec-17
12-02-2017 12-Feb-2017 02-Dec-17
12-04-2017 12-Apr-2017 04-Dec-17
12/13/17 12/13/17 13-Dec-17
12/13/17 12/13/17 13-Dec-17
12/14/17 12/14/17 14-Dec-17
12/15/17 12/15/17 15-Dec-17
regards
Naresh