COMPARING DATES with nested IF not working- Syntax is correct though

[Richard Flame]

Hi,

Is it proper to write this in ExcelThe syntax is correct but not dates format maybe)

=IF(Current_MONTH<=3/31/2006,C7,IF( (AND(Current_MONTH>3/31/2006,Current_MONTH<=6/30/2006)),H7, IF(Current_MONTH>7/1/2006,I7)) ??

It seems that the dates are not being detected properly. the current_month is: 6/30/2006.

Any ideas/suggestions would be much appreciated. Thank u

[Marcelo]

try to use " " on the formula - eg "3/31/2006"

hth
regards from Brazil
Marcelo

"Richard Flame" escreveu:

>
> Hi,
>
> Is it proper to write this in ExcelThe syntax is correct but not
> dates format maybe)
>
> =IF(Current_MONTH<=3/31/2006,C7,IF(
> (AND(Current_MONTH>3/31/2006,Current_MONTH<=6/30/2006)),H7,
> IF(Current_MONTH>7/1/2006,I7)) ??
>
> It seems that the dates are not being detected properly. the
> current_month is: 6/30/2006.
>
> Any ideas/suggestions would be much appreciated. Thank u
>
>
> --
> Richard Flame
> ------------------------------------------------------------------------
> Richard Flame's Profile: http://www.excelforum.com/member.php...o&userid=35944
> View this thread: http://www.excelforum.com/showthread...hreadid=560752
>
>

[JMB]

>>Current_MONTH<=3/31/2006

is interpreted as 3 divided by 31 divided by 2006.

If Current_MONTH is a numeric date (not text), try DATE(2006, 3, 31) or
(--"3/31/2006"), or 38,807.



"Richard Flame" wrote:

>
> Hi,
>
> Is it proper to write this in ExcelThe syntax is correct but not
> dates format maybe)
>
> =IF(Current_MONTH<=3/31/2006,C7,IF(
> (AND(Current_MONTH>3/31/2006,Current_MONTH<=6/30/2006)),H7,
> IF(Current_MONTH>7/1/2006,I7)) ??
>
> It seems that the dates are not being detected properly. the
> current_month is: 6/30/2006.
>
> Any ideas/suggestions would be much appreciated. Thank u
>
>
> --
> Richard Flame
> ------------------------------------------------------------------------
> Richard Flame's Profile: http://www.excelforum.com/member.php...o&userid=35944
> View this thread: http://www.excelforum.com/showthread...hreadid=560752
>
>