date format

[vmjan02]

I have the date in this format "Day: 11 Sep 19", just need date from this "Day: 11 Sep 19" in format as
date format 11-09-2019

any idea.

 

[Peter_SSs]

You will need to either
a) Extract the date to another column (could use a formula or Text to Column or vba code) and then format how you want, or
b) remove the "Day: " from the cell (could use Find/Replace or Text to columns or vba code) and then format how you want.

If you need further help with these ideas, tell us your preference for method and/or location of the results.
Where is the original data?

 

[vmjan02]

Yes, did tried the function but its not working.

 

[Peter_SSs]

Yes, did tried the function but its not working.

In that circumstance best to give the formula you used and what result it did give and explain in what way that is the wrong result.

There are several formulas that could be used. Here is one.

Excel Workbook
	A	B
1	Day: 11 Sep 19	11-Sep-19
Extract Date

 

[vmjan02]

I have in cell a1 as Day: 11 Sep 19 and I did in cell a2 =REPLACE(A1,FIND("Day: ",A1),4,"") -- here replace is done, now in a3 this is not working =TEXT(A2,"mm-dd-yyyy")

You will need to either
a) Extract the date to another column (could use a formula or Text to Column or vba code) and then format how you want, or
b) remove the "Day: " from the cell (could use Find/Replace or Text to columns or vba code) and then format how you want.

If you need further help with these ideas, tell us your preference for method and/or location of the results.
Where is the original data?

 

[Peter_SSs]

I have in cell a1 as Day: 11 Sep 19 and I did in cell a2 =REPLACE(A1,FIND("Day: ",A1),4,"") -- here replace is done, now in a3 this is not working =TEXT(A2,"mm-dd-yyyy")

Did you try the formula I posted?

.. or don't I have the correct text in A1 in my screen shot? If not, what exactly should it be?

 

[vmjan02]

yes, done.

 

[Peter_SSs]

yes, done.

Good news.