Using excel to nest the formula. Wanting to know the date range based on the year and month. The month is actually February for year 2014.

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:

=TEXT(DATE(LEFT(A1,4),RIGHT(A1,2),1),"MMMM YYYY")

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.

Ask Your Question

Weekly Poll