need macro to filter only the date which has the format "mm/dd/yyyy" and not text date

**1Anil** · 12-11-2013, 05:21 AM

Hi All,

I am working on a Excel sheet which has a column with dates ( not only dates but also other text also like akldfjls, asdlf@dfa, aldfj123) and even i have a text in date like 40013, so i need a macro which will filter only the dates which has a format "mm/dd/yyyy".

Any help would be high appreciated.

Thanks to all the Genius who are help the beginners.

Thank you so much in advance even for the people who tried it.

Anil Kumar

**nathansav** · 12-11-2013, 10:35 AM

loop the data, check that the value contains 2 "/"'s and trap the error produced by CDATE(value) if it errors (not a date) hide the row.

need macro to filter only the date which has the format "mm/dd/yyyy" and not text date

LinkBack

Thread Tools

Rate This Thread

Display

need macro to filter only the date which has the format "mm/dd/yyyy" and not text date

Re: need macro to filter only the date which has the format "mm/dd/yyyy" and not text date

Thread Information

Users Browsing this Thread

Similar Threads

Macro-Highlight cells in column D if the date format is other than "mmm-dd-yyyy hh:mm:ss"

[SOLVED] Format a column as date format "yyyy-mm-dd"

Check if the cell format is date and change it to date Format(cell.Value, "yyyy/mm/dd")

VBA - Save AS, filename from cell as date in format "YYYY-MM-DD"

convert string to date format of "d-mmm-yyyy"

Bookmarks

Bookmarks

Posting Permissions