Why won't my IFAND function work. below are the columns in my worksheet and
example of the data that is in each column. However, my formula is returning
a " " or blank cell instead of the number 1 for dates that are greater than
12/1/2004 and less than 1/1/2006

Function Costcenter
unit date

A B
C D
IF(AND(D212/1/2004,D2<1/1/2006),1,"") 1200120 3465
8/1/2005

Looks like 12/1/2004 and 1/1/2006 are division problems to Excel
Try:
=IF(AND(D2DATE(2004,1,12),D2<DATE(2006,1,1)),1,"" )
Beege


"Access Newbie looking for help"
. com wrote in message
...
Why won't my IFAND function work. below are the columns in my worksheet
and
example of the data that is in each column. However, my formula is
returning
a " " or blank cell instead of the number 1 for dates that are greater
than
12/1/2004 and less than 1/1/2006

Function Costcenter
unit date

A B
C D
IF(AND(D212/1/2004,D2<1/1/2006),1,"") 1200120 3465
8/1/2005

Beege's advise helped and corrected my error

"Access Newbie looking for help" wrote:

Why won't my IFAND function work. below are the columns in my worksheet and
example of the data that is in each column. However, my formula is returning
a " " or blank cell instead of the number 1 for dates that are greater than
12/1/2004 and less than 1/1/2006

Function Costcenter
unit date

A B
C D
IF(AND(D212/1/2004,D2<1/1/2006),1,"") 1200120 3465
8/1/2005

That was the problem, thank you for your hlep Beege

"Beege" wrote:

Looks like 12/1/2004 and 1/1/2006 are division problems to Excel
Try:
=IF(AND(D2DATE(2004,1,12),D2<DATE(2006,1,1)),1,"" )
Beege


"Access Newbie looking for help"
. com wrote in message
...
Why won't my IFAND function work. below are the columns in my worksheet
and
example of the data that is in each column. However, my formula is
returning
a " " or blank cell instead of the number 1 for dates that are greater
than
12/1/2004 and less than 1/1/2006

Function Costcenter
unit date

A B
C D
IF(AND(D212/1/2004,D2<1/1/2006),1,"") 1200120 3465
8/1/2005

This is another way

=IF(AND(D2"12/1/2004"+0,D2<"1/1/2006"+0),1,"")


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=524488