Date & < sign I want to Conc.

Hello all,
I have a macro that runs once the user puts
A B
Start Date: >12/15/04
Finish Date: <2/15/05
The filter requires they use a < & > signs, well they don't want to have to
type this in everytime. I know how to use concatenate but it doesn't give it
a value the filter will read then I tried to add the value function and that
said N/A. Have any ideas? I want it to look like
A B C(formula)
> 12/05/04 >12-05-04
< 2/05/05 <02-05-05
And it has to be values the advanced filter will read. Thanks for the help.

Though daily learning, I LOVE EXCEL!
Jennifer

Works fine for me, it always look weird when you concatenates dates since
they will display their serial numbers but it works, I assumed that > was in
A1, < in A2, 12/05/04 in B1 and 2/15/05 in B2

I put 2 headers next to each other in C1 and D1 called Date and in C2 I put
=A1&B1 and in D2 I
put =A2&B2 then I used C1:D2 as criteria

note you can making the criteria look like dates by using
=A1&TEXT(B1,"mm/dd/yy") instead

You can also use a formula leaving the header blank

=AND(CHOOSE(MATCH($A$1,{">","<",">=","<="},0),A5>$B$1,A5<$B$1,A5>=$B$1,A5<=A5),CHOOSE(MATCH($A$2,{">","<",">=","<="},0),A5>$B$2,A5<$B$2,A5>=$B$2,A5<=$B$2))


where A5 is the first date in your list and criteria would be C1:C2 instead

however that would be swimming to the other side of the river for water

--
Regards,

Peo Sjoblom


"Jennifer" <Jennifer@discussions.microsoft.com> wrote in message
news:58CBBBFC-1996-4318-8B2D-E28BEDD85735@microsoft.com...
> Hello all,
> I have a macro that runs once the user puts
> A B
> Start Date: >12/15/04
> Finish Date: <2/15/05
> The filter requires they use a < & > signs, well they don't want to have
> to
> type this in everytime. I know how to use concatenate but it doesn't give
> it
> a value the filter will read then I tried to add the value function and
> that
> said N/A. Have any ideas? I want it to look like
> A B C(formula)
>> 12/05/04 >12-05-04
> < 2/05/05 <02-05-05
> And it has to be values the advanced filter will read. Thanks for the
> help.
>
> Though daily learning, I LOVE EXCEL!
> Jennifer

Thank Peo,
When I run the macro though it doesn't know how to read the formula as
dates. I don't get anything in the filtered.
Jennifer

"Peo Sjoblom" wrote:

> Works fine for me, it always look weird when you concatenates dates since
> they will display their serial numbers but it works, I assumed that > was in
> A1, < in A2, 12/05/04 in B1 and 2/15/05 in B2
>
> I put 2 headers next to each other in C1 and D1 called Date and in C2 I put
> =A1&B1 and in D2 I
> put =A2&B2 then I used C1:D2 as criteria
>
> note you can making the criteria look like dates by using
> =A1&TEXT(B1,"mm/dd/yy") instead
>
> You can also use a formula leaving the header blank
>
> =AND(CHOOSE(MATCH($A$1,{">","<",">=","<="},0),A5>$B$1,A5<$B$1,A5>=$B$1,A5<=A5),CHOOSE(MATCH($A$2,{">","<",">=","<="},0),A5>$B$2,A5<$B$2,A5>=$B$2,A5<=$B$2))
>
>
> where A5 is the first date in your list and criteria would be C1:C2 instead
>
> however that would be swimming to the other side of the river for water
>
> --
> Regards,
>
> Peo Sjoblom
>
>
> "Jennifer" <Jennifer@discussions.microsoft.com> wrote in message
> news:58CBBBFC-1996-4318-8B2D-E28BEDD85735@microsoft.com...
> > Hello all,
> > I have a macro that runs once the user puts
> > A B
> > Start Date: >12/15/04
> > Finish Date: <2/15/05
> > The filter requires they use a < & > signs, well they don't want to have
> > to
> > type this in everytime. I know how to use concatenate but it doesn't give
> > it
> > a value the filter will read then I tried to add the value function and
> > that
> > said N/A. Have any ideas? I want it to look like
> > A B C(formula)
> >> 12/05/04 >12-05-04
> > < 2/05/05 <02-05-05
> > And it has to be values the advanced filter will read. Thanks for the
> > help.
> >
> > Though daily learning, I LOVE EXCEL!
> > Jennifer
>
>