using a date in an IF statement

  • Thread starter Thread starter MP
  • Start date Start date
M

MP

I am trying to put a date in an IF statement, so that the
true equals a number and the false goes to another cell.
The formula I have written returns the correct false
response, but not the correct true response. Here is the
formula
IF(B7="March 31, 2004",90,B129). It also doesn't work if
I put the date as 3/31/04 or 3/31/2004.

Thank you for any assistance
 

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

Help with an IF Formula 5
Using if statements with a date 6
IF Dates 1
return date from range of dates with if statement 3
Using multiple IF statements 1
If a date range contains a leap year (date) 14
IF ISERROR INDIRECT MATCH Formula Question??? 19
If statements?? 2

Back
Top