Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
COMPARING DATES with nested IF not working- Syntax is correct though
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
COMPARING DATES with nested IF not working- Syntax is correct thou
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparing Dates using Greater Than and Less than | Excel Discussion (Misc queries) | |||
working with dates in fiscal years | Excel Worksheet Functions | |||
pivot table dates are out of order how do I correct them | Excel Worksheet Functions | |||
Is there a way to calculate business working days between dates i. | Excel Worksheet Functions | |||
Comparing dates in an IF function | Excel Worksheet Functions |