Filtering The Dates

[Mtr_lover20]

Hi ALL

Here I have one question regarding filtering the dates in excel

I have the column where the date and I am using the Field days option for
the filling. I tried the Autofilter but couldn't filter the dates that I
need. The fact is that I need to show only the every 20th day of each month
but unfortunately it doesn't work or I am mading a mistake.

Can anyone help me with this?

I thank you for your time and support in advance

Regards

 

[Max]

Assuming you've got real dates running in A2 down ..
Use a helper col, put in an empty col to the right, say, K2:
=IF(TEXT(A2,"d")+0=20,"X","")
Copy K2 down to last row of data in col A. This will flag all 20th dates in
col A with an "X". You could then autofilter on col K, choose "X" to get the
filtered results.

 

[Roger Govier]

Hi

Filtering on the date column itself will not work.
Assuming your dates are in column A, starting at row 2, then create
another column with
=A2 as the formula, and Format>Cells>Number>Custom>dd
Copy down as far as required.
Filter for 20 in that new column

--
Regards

Roger Govier


"(e-mail address removed)"

 

[Mtr_lover20]

Max and Roger

Thank you very much it was really helpful and easy to implement
now it works perfectly

I really appreciate for your help

)
regards

 

[Max]

Always good to hear that.
Thanks for feedback to us.