long dates not recognized as dates

[rjmdc]

ji
my date column has dates as long Dtaes december 24, 2024
the cells list cell types as date however i cannot sort or filetr as they eem to be text lso verified by formula =ISNUMBER(DATEVALUE(A2))
most say text

what can I do to fix this?
thanks

 

[kvsrinivasamurthy]

Dates are in text format.
Select the column range Which contains 'Dates'.
Data-->Text to columns-->Next-->Next-->Next
Selelct Date-->select MDY--> Finish.
Now your dates in text form will change to Date format. Go ahead with calculations.

 

[rjmdc]

hi
the ones that are dates work the rest it wont recognize as dates

 

[kvsrinivasamurthy]

Upload sample data in XL2BBformat.

 

[rjmdc]

Sample log.xlsx
	A	B	C	D	E	F
1	SAP	Date	SAP2	✔	Lifeplan	✔ 2
2	✔ LP	January 16, 2019			LP	✔
3		January 29, 2019
4		January 29, 2019
5		January 31, 2019
6		January 31, 2019
7		February 4, 2019
8		February 4, 2019
9		February 4, 2019
10		February 4, 2019
11		February 5, 2019
12		February 5, 2019
13		February 5, 2019
14		February 6, 2019
15		February 6, 2019
16		February 6, 2019
17		February 6, 2019
18		February 6, 2019
19		February 6, 2019
20		February 10, 2019
21		February 10, 2019
22		February 10, 2019
Log (2)

Cells with Data Validation
Cell	Allow	Criteria
A2:A22	List	=#REF!

 

[kvsrinivasamurthy]

B2:B22. Checked . All converted to dates

 

[rjmdc]

hi help me again with the code to revert to dates

 

[kvsrinivasamurthy]

Have you tried post#2

 

[rjmdc]

yes 1/2 my long list of 10000 entries are dates the rest not
when i did a formula =ISNUMBER(DATEVALUE(A2)) the ones i sent you said false
that menas its not a date

 

[Cubist]

=ISNUMBER(DATEVALUE(A2)) the ones i sent you said false

What about without the DATEVALUE?

=ISNUMBER(A2)