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 •

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:


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