Hi everyone,
I would like to filter first days of each month over several years i.e. how I could easily filter my data like "1/1/2010, 1/2/2010 ..... 1/1/2011, 1/2/2011 and etc." Please see attached file.
Thanks
Hi everyone,
I would like to filter first days of each month over several years i.e. how I could easily filter my data like "1/1/2010, 1/2/2010 ..... 1/1/2011, 1/2/2011 and etc." Please see attached file.
Thanks
Use a formula in column E that returns the day number then you can filter on day 1.
Entered in E2 and copied down:
=DAY(A2)
All of your dates are already the 1st of the months (unless you did that just for demonstration purposes).
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Im not sure I understand your question? Your dates are already only 1st of the month
Or did you mean that you only want to show Jan, Feb, Mar (for instance) for all years?
Edit: If you meant only those months, try this, copied down in a helper column - then filter on that helper...
=IF(MONTH(A2)<=3,A2,"")
Last edited by FDibbins; 07-12-2015 at 05:36 PM.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Sorry for the wrong file. Please this file.
Tony's suggestion in post #2 should do what you want
You're welcome. Thanks for the feedback!
If your question has been solved please mark the thread as being solved.
In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.
I am having a similar problem. I update the Data from 5/1 to 6/1 but my pivot table and charts do not read the new data in column A?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks