Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
filtering dates | Excel Discussion (Misc queries) | |||
filtering dates | Excel Discussion (Misc queries) | |||
Filtering dates using a formula | Excel Worksheet Functions | |||
filtering dates | Excel Worksheet Functions | |||
Filtering with dates | Excel Discussion (Misc queries) |