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