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