I have a list of dates in this format (7/20/2013) that go through several months. I would like to make have a formula that takes all of the dates from a specific month out and make a new list of those days. For example, if I have 7/20/2013, 6/28/2013, 8/3/2013, 7/1/2013. I would like to to take only the dates from July and put them in a new list: 7/20/2013, 7/1/2013. Any advice or help please?
hi and welcome to the forum
Have you considered using filters? (Home tab/editing/sort & filter)
you could then either just leave the filtered list like that, or copy/paste the results to a new worksheet?
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
Yeah I could just filter it and copy/paste. I was hoping I could do some formula so it would automatically populate another worksheet with what I needed but the filter feature is easy enough. Thanks!
Another way would be to use an IF() statement in a helper column to test the dates to see if they fall withing the limits you set, and then include a max() statement to create a sequence of numbers. You could then use that sequence in an index/match on the next sheet to extract just those dates that match. Assuming your dates are in column A2, down. something like...
X2 =if(and(A2>=7/1/2013,A2<8/31/13),MAX($X$1:X1)+1,MAX($X$1:X1)) copied down
Then on the next sheet, something like...
=index(sheet1!$A$2:$A$200,match(ROW(A1),$X$2:$X$200,0),1) copied down
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks