Filtering by Dates

[Pibsandsquibs]

Hello, I have a spreadsheet that has multiple shipments recorded either with a past date or dates in the future (up to 2 months).

Is there a way that I can get excel to filter everything automatically that is arriving in the next 21 days as an example and then it automatically updates this on a daily basis

So based on todays date being 29/08/24 everything that has an arrival date between now and the 19/09/24 appears and then tomorrow shipments that have an arrival date between 30/08/24 and 20/09/24 appears adding the 20/09/24 to the list. Thanks

 

[Pibsandsquibs]

@RoryA this has been working well, many thanks. Just one further question

With regards the range is it possible to select the columns you want rather than selecting a range. Say if I just wanted A2, C2, E2 rather than A2:E2.

I have tried adjusting using my limited knowledge but it starts to return an error.

Many thanks

 

[RoryA]

Yes, you can wrap the whole thing in CHOOSECOLS:

=CHOOSECOLS(formula, 1,3,5)

for example

 

[Pibsandsquibs]

Yes, you can wrap the whole thing in CHOOSECOLS:

=CHOOSECOLS(formula, 1,3,5)

for example

Apologies I am a bit confused where I put the details, below is the formula that I am using at the moment

=SORT(FILTER('[Log.xlsx]Log'!A:AN,('[Log.xlsx]Log'!AJ:AJ>=TODAY()+14)*('[Log.xlsx]Log'!AJ:AJ<=TODAY()+20)),36)

 

[RoryA]

=CHOOSECOLS(SORT(FILTER('[Log.xlsx]Log'!A:AN,('[Log.xlsx]Log'!AJ:AJ>=TODAY()+14)*('[Log.xlsx]Log'!AJ:AJ<=TODAY()+20)),36),1,3,5)

for example.