Named range that returns range in column A based on criteria looking at column B

Not quite sure how the best way to word what I want but here goes,

What I have existing is:

In column A
I have a list of names (i.e. 1307081624GILHSSHIRE, which are always made up of date, time, project & name with the date & time as yymmddhhmm). From time to time a new name gets added to the top, forcing all entries down one row).

In column B
I have a list of dates (date formatted) that are "concatenated" from the names in column A (i.e. 08-07-2013).

My objective is to have a named range that looks at column A but only at a portion that is set by a portion of the dates in column B which are between a start date in C1 and an end date in D1. So when I change C1 and/or D1 the named range result will change.

There may be a solution that just looks only at column A as I only added column B as I thought it is best that the searchable column is date formatted?

Any help would be brilliant.
Thanks.

See for tips in this link

http://www.excelforum.com/the-water-...-question.html

=if(and($B2>=$C$1,$B2<=$D$1),"yes","")

See the attached file.

I have changd the formula in B1 (*1) to change the text into date.