Tables: Filtering: a) specific dates; b) 1st day of Month; c) Last day of Month. Possible?

Hi all,

I have a large dataset where each row represents a date. In my data exploration, I desire to (quickly) find:

a) A specific date across all the data. For example the 24th of December for the entire dataset

b) 1st day of a given month. For example the 1st day in January for the entire dataset

c) The last day of a given month. For example the last day in February for the entire dataset

d) 1st/last day of the quarter (I realize this one may be even more tricky)

To make it more difficult - I'd love to be able to do this without creating helper columns.

Is this even possible? Would I need VBA to do it?

I don't expect to have this solved here, but maybe a nudge in the right direction and probably in the end I would have to hire someone to do it.

Thanks in advance.

Elijah

PS: Attaching a sample workbook just in case.

Maybe this:

1st day of a given month. For example the 1st day in January for the entire dataset -

G2:

Please Login or Register  to view this content.

The last day of a given month. For example the last day in February for the entire dataset
G3:

Please Login or Register  to view this content.

1st/last day of the quarter (I realize this one may be even more tricky)
I2 =

Please Login or Register  to view this content.

J2 =

Please Login or Register  to view this content.

I didnt understand your first section:
a) A specific date across all the data. For example the 24th of December for the entire dataset
You want to finf the location? the cell number?

Hi Belinda,

Thank you!

What I desire is to actually filter these days.

Just like I in the sample table can filter (and show only) days which contains "Friday". I would then like to filter days which contains only 1st day of the month (and the other values I suggested).

Best regards.

Elijah

Hello, Bo_Ry,

Many thanks!

I need to see if I can integrate that within my own tables, but it does look like a nice solution. Thank you very much.

However, for 1st day of the quarter, it should be the 1st day of the quarter for the data set. I imagine that will not always be the 1st of month, but 2nd, 3rd, etc. But did not test it.

Best regards.