Date Between IF And Statement

  • Thread starter Thread starter Paperback Writer
  • Start date Start date
P

Paperback Writer

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(D2>DATE(2004,12,31)),(D2<DATE(2006,1,1))),"2005","NO")
 
You have too many parentheses:
IF(AND((D2>DATE(2004,12,31),(D2<DATE(2006,1,1)),"2005","NO")

but a better formula might be:
=IF(YEAR(D2)=2005,2005,"NO")
 
I plug in the formula, and I still get a problem

IF(AND((D2>DATE(2004,12,31),(D2<DATE(2006,1,1)),"2005","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!!
 
One more thing. The formula involves columns D and E.

REVISED

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

Still having problems. :(
 
Try this correction: (I had untested prior).
=IF(AND(D2>DATE(2004,12,31),D2<DATE(2006,1,1)),2005,"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.
 
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")
 
Back
Top