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
|