EXCEL FILTERS

Question

Hi,

Simple question with a likely simple answer.

I'm using excel on Mac.

I want to filter my dates column from 'today' onwards (so every day I open my document, only data from 'today' onwards is displayed).

Help?

Many thanks.

Answer 1

Hello Ben,

Per the description shared, I assume you want to filter the dates automatically and filter based on Today's date and after today's date. If yes, you need to use programming to achieve it but if you are okay to achieve it via few clicks, you can use the Filter feature in the Data tab and use Between to select the dates.

To use the Data> Filter feature: Select the range> Data tab> Filter> Click on the down arrow at Dates column> Select Between in Choose One> Select Today's date at After> Select Or> Then Choose "Equals" and set to Today's date.

If you want to filter the data of Dates separately, you can use the formula like =FILTER(A2:A7,A2:A7>=TODAY(),""). Reference: FILTER function - Office Support (microsoft.com)

Note: Where A2:A7 is the range of Dates.

Thanks for understanding!!

Best Regards,

Chitrahaas

Answer 2

Thanks,

Shane

Answer 3

Hi Shane

Cell formulas work the same on Mac and Windows. You can use the FILTER worksheet function in Excel for Mac.

Answer 4

Hello Ben,

Have you checked the replies provided above? If you need any further help, please feel free to post back to us.

Thanks,

Chitrahaas

Answer 5

I'm not sure you can use the FILTER function on you MAC. An alternative would be to use VBA:

You can add the code shown below to the Workbook Open event:

This code assumes your data is on Sheet4 in the range K1:K28.