Combing months in ONE Cell

H

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!!! :)
 
C

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
 
Top