Dates in IF formula

[wmorrison49]

Here is the formula we are using:

=IF(1/1/2004<='Info Sheet'!$D$46<3/1/2004,'Info Sheet'!$F$46,0)

What it is supposed to do is to check to see if the date in InfoSheet!D46 is between 1/1/2004 and 3/1/2004. Even though this should have been true, it was returning the 0 from the IF statement. We also tried setting up dummy cells with dates in them and changing our 2004 dates to cell references, but that didn't do it either. DOes anyone have any ideas on how to make this work? Thanks, much appreciated.

Will

[daddylonglegs]

Try

=IF(AND("1/1/2004"+0<='Info Sheet'!$D$46,'Info Sheet'!$D$46<"3/1/2004"+0),'Info Sheet'!$F$46,0)

[wmorrison49]

That worked, thanks a lot. What does the AND do?

[daddylonglegs]

Excel has no "between" function and you can't use a construction like

4<=A1<6

so you need to check both conditions. AND function is only true when all clauses are true so you'd use

=IF(AND(4<=A1,A1<6),......

or you can use * like

=IF((4<=A1)*(A1<6),......

[wmorrison49]

Gotcha, I didn't know that. Thank you so much!