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

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

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 FormatCellsNumberCustomdd
Copy down as far as required.
Filter for 20 in that new column

--
Regards

Roger Govier


"
wrote in message
...
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 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

Always good to hear that.
Thanks for feedback to us.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"
wrote in message ...
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