Formula Hell, ...OK, maybe just Formula Heck.

[jeh]

Hi Gang,

This part of my formula work like it should;
=IF(C3>37346,"invalid date","")

I cant figure out how to make the second part work "<37527"

What I'm looking for is =IF(C3>3734OR<37527,"invalid date","")

I cant seem to make it go. Any ideas?

Thanks for your time,

Jim

 

[Flenley]

This should work.

Just adjust the numbers


=IF(AND(C3>1,C3<4),"invalid date","")

 

[Legacy 98055]

You almost had it!

=IF(OR(C3>37346,C3<37527),"Invalid Date","")


This message was edited by TsTom on 2002-08-29 00:00

 

[RichardS]

On 2002-08-28 23:58, TsTom wrote:
You almost had it!

=IF(OR(C3>37346,C3<37527),"Invalid Date","")


This message was edited by TsTom on 2002-08-29 00:00

Won't all dates be either greater than 37346 or less than 37527, in which case they will all be invalid? I think the OP meant if the date falls between the dates, it is invalid, in which case AND would be the correct usage. Please correct me if I'm wrong.

Richard

 

[jeh]

Thanks Everyone,

I guess I should explain my train wreck a little better. If the dates fall between the two numbers, then the date is valid, if its greater or less than the two numbers, it's invalid.

Thanks

 

[Legacy 98055]

Flip the comparison operators:

=IF(OR(C3<37346,C3>37527),"Invalid Date","")
If less than 3/31/2002 OR greater than 9/28/2002...

Most date searches include the beginning and ending dates. Depends on what the OP wants?
Probably:
=IF(AND(C3>=37346,C3<=37527),"Invalid Date","")

Tom

 

[Dragracer]

All you have to do rearrange the code Flenley gave you so it read like this.

<pre>
=IF(AND(C3>37346,C3<37527),"valid","invalid date")
</pre>

 

[jeh]

Thanks Very much,

Burning the 03:30 oil TsTom?

Jim

 

[Legacy 98055]

I was wrong.
Looking at the Opost now, I'm not too sure exactly what they want?
Tom

I work nights and am off tonight.
This message was edited by TsTom on 2002-08-29 00:27

 

[RichardS]

Then swap your signs around in Toms,

=IF(OR(C3<37346,C3>37524),"Invalid Date","")

If date is between March 31 and September 28 inclusive, it returns nothing, otherwise Invalid Date.

Richard