| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dates of a Day for a month & year cell formulas | Excel Discussion (Misc queries) | |||
| copying cell names | Excel Discussion (Misc queries) | |||
| Cell color based upon cell value | Excel Discussion (Misc queries) | |||
| cell color index comparison | New Users to Excel | |||
| VLookup resulting in a blank cell... | Excel Worksheet Functions | |||
Linear Mode
