Write an IF Statement for Dates Between Two Dates (Date Range)

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?
------------------------

[omprakashojha]

Awesome. This lesson resolved my query. Thank you!

[brandenbailey]

This was super helpful! Thank you for putting this together.

[TG]

Thank you so much for the explanation that has just helped me to crack the task.

[zulqurnainahmad]

Excellent, I always had a hard time remembering AND with IF condition, u saved my day. thanks

[andreausa]

This is what exactly i need . All the best wishes to you !

[Tigtigify]

This video just helped me finish a worksheet with multiple references

[imagist.]

THANK YOU.
Exactly what I was looking for

[Serenalambre]

Thank you, thank you, thank you!! Finally an answer to the dreaded date problem within formulas! I have just finished a very lengthy and quite expensive Excel course and I never got the answer to this question. Now can you expand even further and say, 'If the dates are between these ranges then add them up'?

[IvanCortinas_ES]

Great job!! "Value" is also a useful formula.

[willemvantongeren]

Thank you very, very much!! In 5 min. Its all clear.

[BaseStation]

Took me 2 hours to find what I was looking for, but it was here. Found my answer by marker 1:25. THANKS!

[rachelmorris]

Thank you, 3 mins in and i ave my answer. I can go have a cup of tea now with the time I saved.

[mdivyakanth]

thank you so much your logic helped me a lot

[nattroy]

Wow, your video totally solved my problem. I'd been racking my brain and doing GOOGLE searches, but I wasn't even aware of the datevalue function. Thank you!

[TeriBzw]

Thanks, Chester. I am Your number 1 fan, nothing I was trying was working, I was getting frustrated.

[BrucutuPlayer]

Is there a way to find if a date is between a matrix and how many times does it appears ?
for example, if in this sheet that you use is this video there was dates on cells F3...F18 and G3...G18 (matrix), how many times does the cell A8 (08/03/2020) appears on the matrix?
sorry for my bad english, I hope you understood my doubt

[jimt]

Your video is very helpful but I need help finding a Date between a range of dates

I try to find out if a date in my list occurs during DST (Daylight saving time) or Standard time

I need to calculate a time for an event in my spreadsheet and if the date will be during DST (Daylight saving time) they have to add 7 Hours if it falls during winter time that use standard time it should only add 6 hours
So I have a list with 50 events during 10 year periods so I need to find out on every date if its durned DST or Standard time for that year
I do have a table with the dates for DST start/end from 2014 to 2033

[alexc]

what if you have a bunch of date ranges listed under columns A and B and a bunch of separate dates listed under column C, and you wanted the date range cells to highlight if any of the dates listed in C were within them?

[olgapascaru]

What format does the data need to have in order for the function to work?

[mohamedwahdan]

Excellent, thank you, thank you so much,