Excel List Data/Date Filter

Hello guys,

im kinda new to make.com and unable to find a solution for (i guess) a simple automation.

I have an excel-worksheet with columns from A-J. One Column is called “Start”.

I want to extract all rows every month from 01.XX to 31.XX to create a PDF file and make an evaluation. I just need a function/automation to get alle dates from a certain month.

Cheers guys - will be very active and answer as fast as possible!

Welcome to the Make community!

extract all rows every month

You can do that by using the Search Rows module.

Then, you can aggregate the results to an array using an Array Aggregator module.

Screenshot_2024-07-16_170750

samliewrequest private consultation

Join the Make Fans Discord server to chat with other makers!

Is it possible to do it within a filter or with “excel-modules” directly? instead of google sheets - cheers for now! :slight_smile: Will test it now

Like in the picture but without the search rows module.