Solved What is the date range for this 201401?

March 30, 2016 at 05:19:54
Specs: Windows 7
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.

See More: What is the date range for this 201401?

Report •

#1
March 30, 2016 at 07:38:47
✔ Best Answer
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.


Report •
Related Solutions


Ask Question