Filtering dates in Excel

[jaysjay]

Hello:

I have a table containing two columns of dates- a start date and an end date. I realize there's a date filter but that only works for a column of data.

For example, if I would like to filter data in order to show data for 10/2/16- how would I be able to do that if one column shows 10/1/16 and the other 10/5/16?

Thank you in advance!

[mahju]

Hi

If I understand your question, you may try Autofilter

It can filter on more than one column. Also in date filter there is custom filter try this. It has greater or less than option also.

It is batter if you upload a sample file specifying input and output you required.
Regards.

[jaysjay]

Yes, I have tried that but it can't find data between the dates. I've attached the file as an example.

Hi

If I understand your question, you may try Autofilter

It can filter on more than one column. Also in date filter there is custom filter try this. It has greater or less than option also.

It is batter if you upload a sample file specifying input and output you required.
Regards.

[José Augusto]

Hi
Use data filter, custom and choose your date from calendar.

[Tony Valko]

You could add a new column C.

C1 = some date like 10/2/2016

Then, enter this formula in C2 and copy down:

=AND(C$1>=A2,C$1<=B2)

Then you can filter by column C = TRUE

[jaysjay]

You rock, Tony Valko! Thanks everyone for your help!

[Tony Valko]

You're welcome. Thanks for the feedback!

[Aardigspook]

You can also do it without a helper column by using the date filter 'is before or equal to' on the Start Date column, then the filter 'is after or equal to' on the End Date column. The disadvantage of this compared with Tony's solution is that it's harder to change the date you want to filter on - with his you just change C1, but with this dual-filter method you need to change both filters.

[sanram]

This can be done by custom filter also. See the attachment. Click on the filter arrow --> Date Filter --> Custom. Then see what I used there to achieve this.