| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Function that compares dates and returns TRUE or FALSE
Hi,
I'll need to come up with a function that compares each value in column D with '12/31/2005 ' and return TRUE if the value in column D is smaller than '12/31/2005 ', but FALSE if it is greater than '12/31/2005 '. I have the following formula: =(D1<'12/31/2005') But this gives me an error. Also I'l need to know how to apply this formula to other rows. Thanks! -Emily |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| =IF(test,true,false) only ever returns "true"? | Excel Worksheet Functions | |||
| Any number above 15 returns false when it should be true | Excel Worksheet Functions | |||
| If Statement returns true when false? | Excel Discussion (Misc queries) | |||
| Function to return True/False if all are validated as True by ISNU | Excel Worksheet Functions | |||
| First part of "IF" function returns false even if true. ?? | Excel Worksheet Functions | |||
![Emily[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
