| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
What is the syntax to check if a date occurred before a referance.
I am trying to check a column of dates against a reference date to determine
if the dates occurred before the reference date. I am using the following logical expression: IF(A1<"01-Jan-2004", "True","False") column A contains dates like: 01-Feb-2004 The expression provides the correct answer for some dates and the incorrect answer for others. Anyone know the correct syntax for this expression? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| date and time | New Users to Excel | |||
| Date issue between Windows and Macintosh version | Excel Discussion (Misc queries) | |||
| Syntax to check protected status of a worksheet? | Excel Discussion (Misc queries) | |||
| Need help troubleshooting an array formula XLXP on Win2K | Excel Worksheet Functions | |||
| Using formulas to determine date in one cell based on date in anot | Excel Worksheet Functions | |||
Threaded Mode
