Need to identify which rows contain a date in format Jan-59

[HowdeeDoodee]

I have in col A, hyperlinks, words in text, and dates in the format Jan-59. Not all dates equal Jan-59.

I need to identify which rows in col A contain dates so I can copy and move the dates to column C as I delete dates out of col A.

Thank you in advance for any replies.

 

[HowdeeDoodee]

Solved Re: Need to identify which rows contain a date in format Jan-59

=IF(ISNUMBER(DAY(A1)),"date","")

 

[JoeMo]

Re: Solved Re: Need to identify which rows contain a date in format Jan-59

=IF(ISNUMBER(DAY(A1)),"date","")

If col A contains only valid dates, hyperlinks and text entries then any number is a date:

=IF(ISNUMBER(A1),"Date","")

 

[HowdeeDoodee]

Re: Solved Re: Need to identify which rows contain a date in format Jan-59

Thank you JoeMo for the clarification.