| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looking for a Date forming function
I have two cells; A1 and B1 each with a date; in A1 I have 11/01/11
and in B1 I have 11/26/11. Furthermore I named cell A1 StartWeek and cell B1 is named EndWeek. I'd like to have an adjacent cell read 11/01/11 through period ending 11/26/11 But when I enter =concatenate(A1&" through period ending "&B1) I end up with: 11/05/11 through period ending 40873 I also tried =concatenate(StartWeeek&" through period ending "&EndWeek) but I still end up with: 11/05/11 through period ending 40873 Is there some function I can add that would format the second date to appear correctly as 11/26/11 ? Thank you |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Looking for a Date forming function
Il 08/12/2012 00:33, Rob Flott ha scritto:
I have two cells; A1 and B1 each with a date; in A1 I have 11/01/11 and in B1 I have 11/26/11. Furthermore I named cell A1 StartWeek and cell B1 is named EndWeek. I'd like to have an adjacent cell read 11/01/11 through period ending 11/26/11 But when I enter =concatenate(A1&" through period ending "&B1) I end up with: 11/05/11 through period ending 40873 I also tried =concatenate(StartWeeek&" through period ending "&EndWeek) but I still end up with: 11/05/11 through period ending 40873 Is there some function I can add that would format the second date to appear correctly as 11/26/11 ? Thank you =TEXT(A1,"mm/gg/aa")&" through period ending "&TEXT(B1,"mm/gg/aa") E. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Looking for a Date forming function
On Dec 7, 3:58*pm, plinius wrote:
Il 08/12/2012 00:33, Rob Flott ha scritto: I have two cells; A1 and B1 each with a date; in A1 I have 11/01/11 and in B1 I have 11/26/11. *Furthermore I named cell A1 StartWeek and cell B1 is named EndWeek. I'd like to have an adjacent cell read 11/01/11 through period ending 11/26/11 But when I enter =concatenate(A1&" through period ending "&B1) I end up with: * 11/05/11 through period ending 40873 I also tried =concatenate(StartWeeek&" through period ending "&EndWeek) but I still end up with: * 11/05/11 through period ending 40873 Is there some function I can add that would format the second date to appear correctly as 11/26/11 ? Thank you =TEXT(A1,"mm/gg/aa")&" through period ending "&TEXT(B1,"mm/gg/aa") E.- Hide quoted text - - Show quoted text - Thank you...this works great, although I used "mm/dd/yy" instead....THANK YOU :) |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Looking for a Date forming function
Il 08/12/2012 01:09, Rob Flott ha scritto:
On Dec 7, 3:58 pm, plinius wrote: Il 08/12/2012 00:33, Rob Flott ha scritto: I have two cells; A1 and B1 each with a date; in A1 I have 11/01/11 and in B1 I have 11/26/11. Furthermore I named cell A1 StartWeek and cell B1 is named EndWeek. I'd like to have an adjacent cell read 11/01/11 through period ending 11/26/11 But when I enter =concatenate(A1&" through period ending "&B1) I end up with: 11/05/11 through period ending 40873 I also tried =concatenate(StartWeeek&" through period ending "&EndWeek) but I still end up with: 11/05/11 through period ending 40873 Is there some function I can add that would format the second date to appear correctly as 11/26/11 ? Thank you =TEXT(A1,"mm/gg/aa")&" through period ending "&TEXT(B1,"mm/gg/aa") E.- Hide quoted text - - Show quoted text - Thank you...this works great, although I used "mm/dd/yy" instead....THANK YOU :) I forgot to translate :-) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help forming a list | Excel Discussion (Misc queries) | |||
| Pivotting? Transposing? Normal Forming? Crosstabbing? | Excel Discussion (Misc queries) | |||
| Forming a trend line | Excel Worksheet Functions | |||
| Distributing elements forming n groups | Excel Programming | |||
| conditional forming causing linking errors | Excel Worksheet Functions | |||
Hybrid Mode
