| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
if statements & dates?
Is there a problem with using dates in IF statements? I'm trying to ask
Excel to record 0 if the date is 9/9/99, and if it's not 9/9/99 put in the content of the cell: =if(a1=9/9/99,0,a1) It works for dates unless it's 9/9/99 Thanks Lynn |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 2 digit year in dates return 19xx not 20xx | Excel Discussion (Misc queries) | |||
| Default Dates | Excel Discussion (Misc queries) | |||
| Using dates for x-axis values as string instead of creating a scale | Charts and Charting in Excel | |||
| Formating Dates for production schedule | Excel Discussion (Misc queries) | |||
| due dates | New Users to Excel | |||
Threaded Mode
