This shorter version worked, too:

=TEXT((SUBSTITUTE(A1," ","/")&"/01")+31,"yyyy mm")



Dave Peterson wrote:

This worked for me:
=TEXT(DATEVALUE(SUBSTITUTE(A1," ","/")&"/01")+31,"yyyy mm")

Dslady wrote:

I have a four digit space 2 digit cell example (yyyy mm) and I need to ad one
to the month. Is there a way fo doing this?

--

Dave Peterson

--

Dave Peterson