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.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
" wrote:
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