| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF statement not working
This is a formula I have in my Excel spreadsheet that is not working correctly.
=IF(AND("12/1/05"<L2,L2<="2/28/06"),J2,0) This formula works correctly with numbers, but not with dates. I have the L2 cell format as a date. This formula will return 0 when the date in L2 is 12/20/05 for example. If someone could help me with this formula I would really appreciate it. Thanks, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculation with Working day of the year | Excel Discussion (Misc queries) | |||
| Working days left in the month compared to previous months | Excel Worksheet Functions | |||
| Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
| What statement to use? | Excel Worksheet Functions | |||
| Wildcard Not Working in IF statement | Excel Worksheet Functions | |||
Threaded Mode
