If Statement - Date Calculations
 

I have an IF statement that uses dates to determine which value is displayed
in a cell. I am confused as to whether or not to use quotes (" ") in the
formula. With the quotes it works and without the quotes it doesn't work.
Also, if I change the dates and they are greater than 1/1/2002, the for
second formula doesn't work.

Here is the formula:
=IF(AND($A$1<"1/1/2002",$A$31999,$B$1<"1/1/2002",$A$31999),"Monthly","None")

=IF(AND($A$1"12/31/1999",$A$31999,$B$1"12/31/1999",$A$31999),"Monthly","None")


Col A
Col B
Row 1 1/1/1993 1/1/1992
Row 2 $153,564.00
$38,595.00
Row 3 $10,000.00 $2,000.00

If I change the dates to greater than 12/31/2001 than the formula doesn't
work

If Statement - Date Calculations
 

You're dates aren't being evaluated as true Excel dates. They're being
evaluated as TEXT strings.

=IF(AND($A$1<"1/1/2002",

Try one of these methods for each date reference:

=IF(AND($A$1<--"1/1/2002",....
=IF(AND($A$1<DATE(2002,1,1),....
=IF(AND($A$1<E1,...

Where E1 = 1/1/2002

--
Biff
Microsoft Excel MVP


"Tony" wrote in message
...
I have an IF statement that uses dates to determine which value is
displayed
in a cell. I am confused as to whether or not to use quotes (" ") in the
formula. With the quotes it works and without the quotes it doesn't work.
Also, if I change the dates and they are greater than 1/1/2002, the for
second formula doesn't work.

Here is the formula:
=IF(AND($A$1<"1/1/2002",$A$31999,$B$1<"1/1/2002",$A$31999),"Monthly","None")

=IF(AND($A$1"12/31/1999",$A$31999,$B$1"12/31/1999",$A$31999),"Monthly","None")


Col A
Col B
Row 1 1/1/1993 1/1/1992
Row 2 $153,564.00
$38,595.00
Row 3 $10,000.00 $2,000.00

If I change the dates to greater than 12/31/2001 than the formula doesn't
work