Hi.
Let's say that in sheet One I have a column A with all the dates between July 1st 2011 until January 31st 2012 like seen below.
1.07.2011
2.07.2011
...
31.01.2012
I need to extract from this column only the months and years, ordered in another column, in another sheet Two, on column A, like this:
July 2011
August 2011
...
January 2011
Now this is a bit tricky, because I would need that only the months and years that actually exist in the data in sheet One, column A, so that if I have only 1.10.2011 and 1.01.2012, only October 2010 and January 2012 would be listed.
I would appreciate any help with this, I've been busting my head all day. It would be perfect if I could solve this without using VB scripts.
Many thanks in advance!
Let's say that in sheet One I have a column A with all the dates between July 1st 2011 until January 31st 2012 like seen below.
1.07.2011
2.07.2011
...
31.01.2012
I need to extract from this column only the months and years, ordered in another column, in another sheet Two, on column A, like this:
July 2011
August 2011
...
January 2011
Now this is a bit tricky, because I would need that only the months and years that actually exist in the data in sheet One, column A, so that if I have only 1.10.2011 and 1.01.2012, only October 2010 and January 2012 would be listed.
I would appreciate any help with this, I've been busting my head all day. It would be perfect if I could solve this without using VB scripts.
Many thanks in advance!