R
Rob Flott
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
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