Alright, totally forgot but there a twist in the problem.
I need to add mmm'yy according to a given set of Date range. For example : From Oct/1/2012 - Oct/25/2012 the Month is Oct'13 and it should change to Nov'13 as soon as date changes to Oct/26/2012 . Any help on this would be appreciated...
Hi, I am working on an excel data and there are two columns - in the first column there are dates given in d/mmm/yy format and in the next column I haven to add Month to which the date pertains. For example - 1-May-2013 and in the Month I want May'13, and 4-Apr-2013 and in the Month I want...