| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Question - 12/1/2007 & "through" & 12/31/2007
Guru's,
I am racking my brain again with another date related issue. Hoping you can smack some sense into me. :o) My worksheet data looks like this: (comma seperated) Start Date,End Date,Message 12/1/2007,12/31/2007,=a2&" thru "&b2 1/1/2008,1/30/2008,=a3&" thru "&b3 The results in column c is as follows: Message 39417 thru 39447 39448 thru 39477 .... and I would like it to be like this instead: Message 12/1/2007 thru 12/31/2007 1/1/2008 thru 1/30/2008 Any help you can provide would be greatly appreciated. Thanks in advance, Scott |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date Question - 12/1/2007 & "through" & 12/31/2007
Try this:
=TEXT(A2,"MM/DD/YYYY")&" thru "&TEXT(B2,"MM/DD/YYYY") Does that help? -------------------------- Regards, Ron (XL2003, Win XP) Microsoft MVP (Excel) "porter444" wrote in message ... Guru's, I am racking my brain again with another date related issue. Hoping you can smack some sense into me. :o) My worksheet data looks like this: (comma seperated) Start Date,End Date,Message 12/1/2007,12/31/2007,=a2&" thru "&b2 1/1/2008,1/30/2008,=a3&" thru "&b3 The results in column c is as follows: Message 39417 thru 39447 39448 thru 39477 ... and I would like it to be like this instead: Message 12/1/2007 thru 12/31/2007 1/1/2008 thru 1/30/2008 Any help you can provide would be greatly appreciated. Thanks in advance, Scott |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date Question - 12/1/2007 & "through" & 12/31/2007
AWESOME!!!
Thank you! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date Question - 12/1/2007 & "through" & 12/31/2007
I'm glad I could help....Thanks for the feedback.
Regards, Ron (XL2003, Win XP) Microsoft MVP (Excel) "porter444" wrote in message ... AWESOME!!! Thank you! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007: top of screen "File Name [Group]", how to remove [Grou | Excel Discussion (Misc queries) | |||
| How can you "save as" in excel 2007 (and word 2007)? | Excel Discussion (Misc queries) | |||
| Typing "true" excel 2007 change it to "TRUE" | Excel Discussion (Misc queries) | |||
| In Excel 2007 PivotTables, what happened to "hiding" subtotal line | Excel Discussion (Misc queries) | |||
| How do I find the "Show Pages..." Pivot table feature in 2007? | Excel Discussion (Misc queries) | |||
Linear Mode
