|
btw..i. am looking for a "short" way of doing it..
What I am doing now is basically adding 3 extra columns, one to fetch month(), one to fetch year(), and then combine the 2 strings in the 3rd columns. (*so I get result like "2009-05" for all the dates in 2009 May)
I am hoping I can do that w/o adding the extra columns or writing a very long function formula.
Is there any present function or shorter way of doing it?xcel that can do that
|