date format in IF statement

  • Thread starter Thread starter george adamides
  • Start date Start date
G

george adamides

Hi
In the If function can I use a cell that has a date in it to check if
true or false and then take the appropriate action? Specifically if
the date entered in cell A1 is 10/10/02 do this in cell A10 else do
that...

Also if anyone can suggest a URL that has information about modeling
in EXCEL (besides financial modeling) please let me know.

Thank you
 
Hi

into A10 enter the formula
=IF(A1=DATE(2002,10,10),FormulaForTrue,FormulaForFalse)
 
Back
Top