Excel filter questions

Question

Hi, I need to know how to do the following filters:

• Filter a date column to show weekend dates only
• Filter a date column to show the first and last day of a month only
• Filter a number column to show round numbers only (e.g. include show 12 but filter out things like 12.12)

Thanks.

Answer 1

Here are some formulae that will be true for the rows you want.

Copy these into another column, and you can then filter the rows based on the truth value of the column.

Formulae assume the value to be examined is stored in A1.

Is a weekend:

 =WEEKDAY(A1,3)>=5

Is the first or last day of the month:

=OR(DAY(A1)=1,DAY(A1+1)=1)

Is a round number:

 =A1=INT(A1)