Extracting a Date from a YYYYMM number
Try this:
With
A YYYYMM value in A1
B1: =DATE(LEFT(D13,4),RIGHT(D13,2)+1,0)
Format B1 as a date
If A1: 200603
B1 returns 03/31/2006
Is that something you can work with?
***********
Regards,
Ron
XL2002, WinXP
"Matt" wrote:
Hi Guys
I have a column of dates in the format YYYYMM and I want to extract a date
from this. Specifically the last day of the month mentioned
I was thinking =TEXT(MID(A22,5,2),"MMM") would return me Feb as it is
pointing at the '02' the second month. But it returns 'Jan', presumbly
becausing it is picking up 2nd of Jan 1900.
Then I was going to use something like ="MONTH(E2)+1" to give me the last
day of the month. Didn't work out though....
Thanks for reading this far, and for any help you might be able to give me
Matt
|