Combing months in ONE Cell
 

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

Combing months in ONE Cell
 

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


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

Combing months in ONE Cell
 

Worked like a charm. ;) Thank you!!!


--
Hansel
------------------------------------------------------------------------
Hansel's Profile: http://www.excelforum.com/member.php...o&userid=24470
View this thread: http://www.excelforum.com/showthread...hreadid=497650