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

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.

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

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