Excel IF function question

K

kjtr

Joined
Apr 2, 2010
Messages
2
Reaction score
0
Trying to produce a value if a date falls within a specified date range (4/9/2010 to 4/22/2010). Any date outside of that range would produce a 0 (or return nothing).

This is my formula, but obviously the value in D10 will display on any date before 4/9/10 and after 4/22/2010, which I do not want. I added logical tests for any date prior to 4/9/2010 and after 4/22/2010 to produce a 0, but got an error that I had too many logical tests for this function.

=IF(E6>=DATE(2010,4,9),D10,IF(E6<=DATE(2010,4,22),D10))

Solution?
 
OK, I think I am a step closer with this formula:

=IF(E6<DATE(2010,4,9),IF(E6>DATE(2010,4,22),0,D10))

However, it is returning the value in D9 instead of a 0 for the dates prior to 4/9/2010, and it is returning FALSE for dates after 4/9/10. Three problems:

1. the true/false result is reversed even though I am following the proper logical test string.
2. it is displaying the word FALSE instead of a 0.
3. it is not recognizing the second argument, so all dates above 4/9 will display the same result.

If someone out there is familiar with these formulas I'd really appreciate the guidance. Thanks!
 
Last edited:
Back
Top