Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2
Default Filtering The Dates

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
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Filtering The Dates

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

  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2,886
Default Filtering The Dates

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



  #4   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2
Default Filtering The Dates

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
  #5   Report Post  
Posted to microsoft.public.excel.newusers
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Filtering The Dates

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





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
filtering dates KJ Excel Discussion (Misc queries) 3 December 29th 06 07:34 PM
filtering dates mindy Excel Discussion (Misc queries) 3 September 9th 05 09:20 PM
Filtering dates using a formula Sue Excel Worksheet Functions 5 July 26th 05 11:02 PM
filtering dates [email protected] Excel Worksheet Functions 3 June 20th 05 05:53 PM
Filtering with dates T Excel Discussion (Misc queries) 1 December 29th 04 07:01 PM


All times are GMT +1. The time now is 12:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"