How to filter data based on current date

Question

I have an Excel file with 3 tabs. The first tab is data filling in from a Microsoft Form, this data includes a column with a date field called "Date of Event".  The second tab is called Future Events and the third tab is called Past Events.  I copied the table from the Forms tab and pasted special using a link to the Future and Past Events tab. That all worked great. Now I need the rows on the Future Events tab to only display if their Date of Event is greater than or equal to the current date.  I need the rows on the Past Events tab to display only if they are less than the current date.  I have attempted to use the Advanced formatting, but it will only allow you to select an actual date, the Today() formula does not appear to be working. I attempted to use Data Validation and while you can add a validation for Date is greater than or equal to Today(), it does not see my column as a Date field and so is doing this validation on all fields in the table. Any other ideas?

Answer 1

https://www.extendoffice.com/documents/excel/5151-excel-filter-date-before-today.html#:~:text=In%20fact%2C%20the%20Filter%20feature%20in%20Excel%20can,the%20date%20picker%20calendar%2C%20see%20screesnhot%3A%20More%20items

Answer 2

I don't see a way to upload a file in this forum, am I missing something obvious?

Here is a screenshot of the first tab called Form 1 that will fill in with information from a Microsoft Form:

Here is the first tab called Future Events, the data is a copy and paste special (as a link) from the Form 1 tab:

All I want to see here is the events that will be in the future, so if today's date is March 6, then I would expect to only see the last 3 events.

Similar with the tab called Past Events, I would only want to see the top 2 events as they are already past.

Thanks

Answer 3

Could you share some dummy data and expected result? Base on your result, we can give you some formula suggestions to meet your goal.

Answer 4

Hi,

Use the FILTER() function. To receive any further help, share some data to work with and show the expected result.

Answer 5

Maybe conditional formatting? https://www.howtogeek.com/770876/how-to-use-conditional-formatting-based-on-date-in-microsoft-excel/