Download the featured file here (including completed formula) https://excels-if-function.com/2020/0...

This video demonstrates how to write an IF statement where you want to test for dates that occur between two dates. The video features three functions: IF, AND and DATEVALUE.

The video looks at three ways you can achieve the IF statement result for date ranges.

This video will be useful to you if you are asking the following questions:
How do you write an IF statement between two dates?
How do you use IF in a date range?
How do I return a value if date within range?
If date is between two dates then how do I return a value?
How do I use an IF function in Excel for dates?
How do you find the value if the date falls between two dates?
------------------------