date format in IF statement

  • Thread starter george adamides
  • 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
 
A

Arvi Laanemets

Hi

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem using IF statement with dates as part of the formula 4
Page numbering with Merged Document and IF statements 1
Logical formatting for multiple values 1
Event recognition. 11
Show a cell's formula in text format in a linked cell 2
Excel function needed 24
IF Statement on multiple levels 6
Unable to nest my IF statements properly 2

Top