software

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 quot; quot; 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(D2gt;12/1/2004,D2lt;1/1/2006),1,quot;quot;) 1200120 3465
8/1/2005Looks like 12/1/2004 and 1/1/2006 are division problems to Excel
Try:
=IF(AND(D2gt;DATE(2004,1,12),D2lt;DATE(2006,1,1)),1,quot;quot; )
Beegequot;Access Newbie looking for helpquot;
. comgt; wrote in message
...
gt; Why won't my IFAND function work. below are the columns in my worksheet
gt; and
gt; example of the data that is in each column. However, my formula is
gt; returning
gt; a quot; quot; or blank cell instead of the number 1 for dates that are greater
gt; than
gt; 12/1/2004 and less than 1/1/2006
gt;
gt; Function Costcenter
gt; unit date
gt;
gt; A B
gt; C D
gt; IF(AND(D2gt;12/1/2004,D2lt;1/1/2006),1,quot;quot;) 1200120 3465
gt; 8/1/2005
gt;
Beege's advise helped and corrected my error

quot;Access Newbie looking for helpquot; wrote:

gt; Why won't my IFAND function work. below are the columns in my worksheet and
gt; example of the data that is in each column. However, my formula is returning
gt; a quot; quot; or blank cell instead of the number 1 for dates that are greater than
gt; 12/1/2004 and less than 1/1/2006
gt;
gt; Function Costcenter
gt; unit date
gt;
gt; A B
gt; C D
gt; IF(AND(D2gt;12/1/2004,D2lt;1/1/2006),1,quot;quot;) 1200120 3465
gt; 8/1/2005
gt;

That was the problem, thank you for your hlep Beege

quot;Beegequot; wrote:

gt; Looks like 12/1/2004 and 1/1/2006 are division problems to Excel
gt; Try:
gt; =IF(AND(D2gt;DATE(2004,1,12),D2lt;DATE(2006,1,1)),1,quot;quot; )
gt; Beege
gt;
gt;
gt; quot;Access Newbie looking for helpquot;
gt; . comgt; wrote in message
gt; ...
gt; gt; Why won't my IFAND function work. below are the columns in my worksheet
gt; gt; and
gt; gt; example of the data that is in each column. However, my formula is
gt; gt; returning
gt; gt; a quot; quot; or blank cell instead of the number 1 for dates that are greater
gt; gt; than
gt; gt; 12/1/2004 and less than 1/1/2006
gt; gt;
gt; gt; Function Costcenter
gt; gt; unit date
gt; gt;
gt; gt; A B
gt; gt; C D
gt; gt; IF(AND(D2gt;12/1/2004,D2lt;1/1/2006),1,quot;quot;) 1200120 3465
gt; gt; 8/1/2005
gt; gt;
gt;
gt;
gt;


This is another way

=IF(AND(D2gt;quot;12/1/2004quot; 0,D2lt;quot;1/1/2006quot; 0),1,quot;quot;)--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=524488