Filtering The Dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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)"
 
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
 
Back
Top