How to pick up only the dates inputs from a column with differnt kind of characters.

Hi Sokol,

Your request is not clear to me, please elaborate using an example scenario. thanks.


Regards,
DILIPandey
<click on below * if this helps>

Your actual dates may be more tricky than your sample, but try this code.

Please Login or Register  to view this content.

1) Pls don't post the same request twice

http://www.excelforum.com/excel-form...of-inputs.html

2)

I've send you a message to your private e-mail address at gmail.com

This is against of rule#4 of our forum that says:

.

.4. Don't Private Message or email Excel questions to moderators or other members. (or Word, Access, etc.) The point of having a public forum is to share solutions to common (and sometimes uncommon) problems with all members.

Thanks Fotis.

Sokol,

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.

Also,

It has come to our attention you have violated Rule 4 of our Forum RULES. Don't Private Message, Visitor message or email Excel questions to moderators or other members. (Or Access, Word, etc.)

All questions and answers will benefit other posters like yourself. The point of having a public forum is to share solutions to common (and sometimes uncommon) problems with all members.

Breaking this rule is considered harrasment by most of our contributors and will not be tolerated. Repeat offense could lead to permanent ban, so do take this caution to heart.

Post your question in a public thread and our many contributors will come to you to assist, especially if the title is accurate (see Rule #1) and you include a sample desensitized workbook that makes it easy for others to try and help.