Date Between IF And Statement
 

Can someone help with my logic? I can't seem to figure this out.

I want it to say "2005" if the date is between 12/31/2004 and 01/01/2006. I
keep getting an error.

Here is my formula.

IF((AND(D2DATE(2004,12,31)),(D2<DATE(2006,1,1))), "2005","NO")

Date Between IF And Statement
 

You have too many parentheses:
IF(AND((D2DATE(2004,12,31),(D2<DATE(2006,1,1)),"2 005","NO")

but a better formula might be:
=IF(YEAR(D2)=2005,2005,"NO")
--
John C


"Paperback Writer" wrote:

Can someone help with my logic? I can't seem to figure this out.

I want it to say "2005" if the date is between 12/31/2004 and 01/01/2006. I
keep getting an error.

Here is my formula.

IF((AND(D2DATE(2004,12,31)),(D2<DATE(2006,1,1))), "2005","NO")

Date Between IF And Statement
 

I plug in the formula, and I still get a problem

IF(AND((D2DATE(2004,12,31),(D2<DATE(2006,1,1)),"2 005","NO")

Is this the corrected formula?

I can't use yours because it is year specific. I need variants that will
allow me to specify dates.

Thanks!!


"John C" wrote:

You have too many parentheses:
IF(AND((D2DATE(2004,12,31),(D2<DATE(2006,1,1)),"2 005","NO")

but a better formula might be:
=IF(YEAR(D2)=2005,2005,"NO")
--
John C


"Paperback Writer" wrote:

Can someone help with my logic? I can't seem to figure this out.

I want it to say "2005" if the date is between 12/31/2004 and 01/01/2006. I
keep getting an error.

Here is my formula.

IF((AND(D2DATE(2004,12,31)),(D2<DATE(2006,1,1))), "2005","NO")

Date Between IF And Statement
 

One more thing. The formula involves columns D and E.

REVISED

IF(AND((D2DATE(2004,12,31),(E2<DATE(2006,1,1)),"2 005","NO")

Still having problems. :(



"Paperback Writer" wrote:

I plug in the formula, and I still get a problem

IF(AND((D2DATE(2004,12,31),(D2<DATE(2006,1,1)),"2 005","NO")

Is this the corrected formula?

I can't use yours because it is year specific. I need variants that will
allow me to specify dates.

Thanks!!


"John C" wrote:

You have too many parentheses:
IF(AND((D2DATE(2004,12,31),(D2<DATE(2006,1,1)),"2 005","NO")

but a better formula might be:
=IF(YEAR(D2)=2005,2005,"NO")
--
John C


"Paperback Writer" wrote:

Can someone help with my logic? I can't seem to figure this out.

I want it to say "2005" if the date is between 12/31/2004 and 01/01/2006. I
keep getting an error.

Here is my formula.

IF((AND(D2DATE(2004,12,31)),(D2<DATE(2006,1,1))), "2005","NO")

Date Between IF And Statement
 

Try this correction: (I had untested prior).
=IF(AND(D2DATE(2004,12,31),D2<DATE(2006,1,1)),200 5,"NO")

This should work.

I can modify my other formula as well, say, for example, the year specific
that you are looking for is in cell H1, you could use this formula, and
modify the year as needed:
=IF(YEAR(D2)=$H$1,$H$1,"NO")
All you would need to do is type the year that you are checking for, in this
case, 2005.


--
John C


"Paperback Writer" wrote:

I plug in the formula, and I still get a problem

IF(AND((D2DATE(2004,12,31),(D2<DATE(2006,1,1)),"2 005","NO")

Is this the corrected formula?

I can't use yours because it is year specific. I need variants that will
allow me to specify dates.

Thanks!!


"John C" wrote:

You have too many parentheses:
IF(AND((D2DATE(2004,12,31),(D2<DATE(2006,1,1)),"2 005","NO")

but a better formula might be:
=IF(YEAR(D2)=2005,2005,"NO")
--
John C


"Paperback Writer" wrote:

Can someone help with my logic? I can't seem to figure this out.

I want it to say "2005" if the date is between 12/31/2004 and 01/01/2006. I
keep getting an error.

Here is my formula.

IF((AND(D2DATE(2004,12,31)),(D2<DATE(2006,1,1))), "2005","NO")

Date Between IF And Statement
 

You've still got your parentheses wrong. Go through the formula and check
which pairs match. Excel will usually colour the parentheses (while you are
editing the formula) to help you in this process.

Try =IF(AND(D2DATE(2004,12,31),D2<DATE(2006,1,1)),"20 05","NO")
--
David Biddulph

"Paperback Writer" wrote in
message ...
I plug in the formula, and I still get a problem

IF(AND((D2DATE(2004,12,31),(D2<DATE(2006,1,1)),"2 005","NO")

Is this the corrected formula?

I can't use yours because it is year specific. I need variants that will
allow me to specify dates.

Thanks!!


"John C" wrote:

You have too many parentheses:
IF(AND((D2DATE(2004,12,31),(D2<DATE(2006,1,1)),"2 005","NO")

but a better formula might be:
=IF(YEAR(D2)=2005,2005,"NO")
--
John C


"Paperback Writer" wrote:

Can someone help with my logic? I can't seem to figure this out.

I want it to say "2005" if the date is between 12/31/2004 and
01/01/2006. I
keep getting an error.

Here is my formula.

IF((AND(D2DATE(2004,12,31)),(D2<DATE(2006,1,1))), "2005","NO")

Date Between IF And Statement
 

It is no more specific than yours. Plug 2005 into a cell, and it is a simple
change

=IF(YEAR(D2)=$M$1,$M$1,"No")

--
__________________________________
HTH

Bob

"Paperback Writer" wrote in
message ...
I plug in the formula, and I still get a problem

IF(AND((D2DATE(2004,12,31),(D2<DATE(2006,1,1)),"2 005","NO")

Is this the corrected formula?

I can't use yours because it is year specific. I need variants that will
allow me to specify dates.

Thanks!!


"John C" wrote:

You have too many parentheses:
IF(AND((D2DATE(2004,12,31),(D2<DATE(2006,1,1)),"2 005","NO")

but a better formula might be:
=IF(YEAR(D2)=2005,2005,"NO")
--
John C


"Paperback Writer" wrote:

Can someone help with my logic? I can't seem to figure this out.

I want it to say "2005" if the date is between 12/31/2004 and
01/01/2006. I
keep getting an error.

Here is my formula.

IF((AND(D2DATE(2004,12,31)),(D2<DATE(2006,1,1))), "2005","NO")