|I'm not sure what you are trying to accomplish.|
re: "Using excel to nest the formula"
I don't know what that means. What formula are you "nesting"?
Are you trying to extract the Month and Year from a 6 digit number? If so, try this:
With 201401 in A1, place this in any cell:
That formula will return January 2014.
I'm not sure why you say that 201401 is "February for year 2014". Please explain.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.