Hi All,
I have a situation were in I need to Find dates in a sentence. For example: the format looks like this: You have 3 cells:
Day 1
Month 1
Year 2012
and a cell which has sentences which contains dates that are in this format - 1 January 2012
There are instance where in day cell or month cell can be empty but year is available. So the code should find either of the information in the sentence
Can anyone help me in providing a VBA code for it?
Bookmarks