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 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