FILTER data between two dates

Hi - Dave here. Happy Friday! Of all the new functions in Excel, I think the FILTER function is the most generally useful because it lets you extract just the data you want to see. One problem that comes up often with FILTER is how to filter values between two dates, as seen in the worksheet below. Basically, we want to look for dates that are greater than or equal to a start date in F5 and less than or equal to an end date in G5. Then we want to extract the corresponding data. You might think we can use the AND function inside FILTER to solve this problem. However, because AND returns just a single value, this won't work. Instead, we use something called Boolean logic to test the dates. [Extract records between dates with FILTER]( [[Download the workbook and read the full explanation](] Read the complete explanation at the link above. If you are new to FILTER, we have a good overview with many examples here: [How to use the FILTER function]( You can find video links near the bottom. Excel formulas We maintain a list of over 500 working formulas [here](. If you need more structure, we also offer [video training](. Have a great weekend! Dave [View this email in a browser]( [Exceljet Logo]( Exceljet P.O. Box 4804 Salt Lake City, UT 84110 Copyright © 2023 Exceljet, All rights reserved. You received this email because you are subscribed to our newsletter. To unsubscribe, click the link below. [Unsubscribe](