Extract Dates from String

**djblois1** · 07-15-2011, 11:31 AM

I want to be able to extract dates (where excel recognizes it as a date) from a string.

Here are some samples:

From JAN-01-2011 To JAN-15-2011
From JAN-01-2010

it will always be in one of those two formats but the dates will change.

**davegugg** · 07-15-2011, 11:46 AM

Please Login or Register  to view this content.

Here is one way to find the three dates.

**snb** · 07-15-2011, 12:14 PM

Please Login or Register  to view this content.

**djblois1** · 07-15-2011, 01:17 PM

Originally Posted by snb

Please Login or Register  to view this content.

snb,

That works great!! You are the man. I just need to do three other things with it:

1) They need to be saved in two separate variables
2) They need to be in date format
3) It also needs to work if the sting only has one date in it (like the example I gave) - I think this one, I can just use part of davegugg's code but if you can think of a more efficient way, then I am all ears.

btw, davegugg thank you for your help too. I appreciate everyone's help. And you gave me a few ideas as well.

**djblois1** · 07-15-2011, 02:09 PM

Here is what I have so far:

Please Login or Register  to view this content.

I need to do 3 things with this code now:

1) They need to be saved in two separate variables
2) They need to be in date format
3) It also needs to work if the sting only has one date in it (like the example I gave)

**davegugg** · 07-15-2011, 02:12 PM

The code I posted was already set up to do those three things:

Please Login or Register  to view this content.

**djblois1** · 07-15-2011, 02:21 PM

Thank you - it actually works great. Quick question:

does this:

Please Login or Register  to view this content.

mean that I can use a stra(0), Stra(1), and a Stra(2)?

if so why didn't you use:

Please Login or Register  to view this content.

Can I use that for any variable?

**davegugg** · 07-15-2011, 02:31 PM

It declares the variable as an array with three members. I really only needed two. You can easily find more info on vba arrays by doing a quick Google search. You could also set up the date variable as an array.