Thread: COMPARING DATES with nested IF not working- Syntax is correct though
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
JMB JMB is offline
external usenet poster
  
Posts: 2,062
Default COMPARING DATES with nested IF not working- Syntax is correct thou
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 Excel:(The syntax is correct but not
dates format maybe)

=IF(Current_MONTH<=3/31/2006,C7,IF(
(AND(Current_MONTH3/31/2006,Current_MONTH<=6/30/2006)),H7,
IF(Current_MONTH7/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


Reply With QuoteReply With Quote