Combing months in ONE Cell

[Hansel]

Hello! I am trying to put the current month and 1 month forward in one cell. I have January 3, 2006 in cell J1, and I want to reference that cell by taking out the current month and the next month. Thus, I want the final product in the new cell to be: Jan-Feb. Here is the equation I have so far:

=DATE(YEAR(J1),MONTH(J1),DAY($J$1))&"-"&DATE(YEAR($J$1),MONTH($J$1)+1,DAY($J$1))

I keep getting this number for my answer: 38720-38751

Can someone please show me the correct equation. Thank you so much for you help!!!

[CLR]

=TEXT(DATE(YEAR(J1),MONTH(J1),DAY($J$1)),"mmm")&"-"&TEXT(DATE(YEAR($J$1),MONTH($J$1)+1,DAY($J$1)),"mmm")


Vaya con Dios,
Chuck, CABGx3


"Hansel" wrote:

>
> Hello! I am trying to put the current month and 1 month forward in one
> cell. I have January 3, 2006 in cell J1, and I want to reference that
> cell by taking out the current month and the next month. Thus, I want
> the final product in the new cell to be: Jan-Feb. Here is the equation
> I have so far:
>
> =DATE(YEAR(J1),MONTH(J1),DAY($J$1))&"-"&DATE(YEAR($J$1),MONTH($J$1)+1,DAY($J$1))
>
> I keep getting this number for my answer: 38720-38751
>
> Can someone please show me the correct equation. Thank you so much for
> you help!!!
>
>
> --
> Hansel
> ------------------------------------------------------------------------
> Hansel's Profile: http://www.excelforum.com/member.php...o&userid=24470
> View this thread: http://www.excelforum.com/showthread...hreadid=497650
>
>

[Hansel]

Worked like a charm. Thank you!!!