Hi - Dave here.
This week, I have an example that shows how to list dates that are expiring soon. In the worksheet shown below, the formula in G5 is:
=SORT(FILTER(data,data[Expires]-date<=days),4)
where
data is an Excel Table in the range B5:E16, and
date (H2) and
days (J2) are named ranges The result is the five rows in the table with an expiration date in the next 15 days:
[
download the workbook and read the full explanation]
This formula is based on the new FILTER and SORT functions, which are available only in Excel 365 and Excel 2022. The article provides a detailed explanation and includes the Excel workbook. Download the workbook and try it out yourself.
You can use this same approach to filter on any data that has an upcoming date. i.e. retirements, events, renewals, etc.
Excel formulas
We maintain a large list of working formulas
here.
If you need more structure, we also offer
video training.
Have a fun and safe weekend!
Dave
