Merge two cells with dates to create a date range
 

Hello, I would like to Merge to cells with dates to create a date range example

A B c
dstartdate denddate Date Range

8/25/2008 9/21/2008 8/25/09-9/21/08

If I use the formula =A2&"-"&B2 I have to put a (') in front of each date in
column A and B otherwise it comes out as unformatted numbers and I can't use
the format to date to fix it.

Merge two cells with dates to create a date range
 

=TEXT(A2,"m/dd/yy")&"-"&TEXT(B2,"m/dd/yy")
but please don't merge cells.
Concatenating the contents is fine, but merging cells causes countless
problems (as the archives of the group will show).
--
David Biddulph

"Need Letters in the Columns"
wrote in message
...
Hello, I would like to Merge to cells with dates to create a date range
example

A B c
dstartdate denddate Date Range

8/25/2008 9/21/2008 8/25/09-9/21/08

If I use the formula =A2&"-"&B2 I have to put a (') in front of each date
in
column A and B otherwise it comes out as unformatted numbers and I can't
use
the format to date to fix it.

Merge two cells with dates to create a date range
 

Try it this way:

=TEXT(A2,"m/dd/yy")&"-"&TEXT(B2,"m/dd/yy")

then copy it down.

Hope ths helps.

Pete

On Jan 27, 8:51*pm, Need Letters in the Columns
wrote:
Hello, I would like to Merge to cells with dates to create a date range example

A * * * * * * * * *B * * * * * * *c
dstartdate * * *denddate * Date Range

8/25/2008 * * * 9/21/2008 *8/25/09-9/21/08

If I use the formula =A2&"-"&B2 I have to put a (') in front of each date in
column A and B otherwise it comes out as unformatted numbers and I can't use
the format to date to fix it.

Merge two cells with dates to create a date range
 

Use
=text(A1,"mm/dd/yyyy") & "-" & text (B1,"mm/dd/yyyy")

Text() will convert the dates to text and then concatenate
"Need Letters in the Columns" wrote:

Hello, I would like to Merge to cells with dates to create a date range example

A B c
dstartdate denddate Date Range

8/25/2008 9/21/2008 8/25/09-9/21/08

If I use the formula =A2&"-"&B2 I have to put a (') in front of each date in
column A and B otherwise it comes out as unformatted numbers and I can't use
the format to date to fix it.

Merge two cells with dates to create a date range
 

=TEXT(A2,"mm/dd/yy")&" - "&TEXT(B2,"mm/dd/yy")


Gord Dibben MS Excel MVP

On Tue, 27 Jan 2009 12:51:02 -0800, Need Letters in the Columns
wrote:

Hello, I would like to Merge to cells with dates to create a date range example

A B c
dstartdate denddate Date Range

8/25/2008 9/21/2008 8/25/09-9/21/08

If I use the formula =A2&"-"&B2 I have to put a (') in front of each date in
column A and B otherwise it comes out as unformatted numbers and I can't use
the format to date to fix it.

Merge two cells with dates to create a date range
 

Thank you it worked perfect.

"Pete_UK" wrote:

Try it this way:

=TEXT(A2,"m/dd/yy")&"-"&TEXT(B2,"m/dd/yy")

then copy it down.

Hope ths helps.

Pete

On Jan 27, 8:51 pm, Need Letters in the Columns
wrote:
Hello, I would like to Merge to cells with dates to create a date range example

A B c
dstartdate denddate Date Range

8/25/2008 9/21/2008 8/25/09-9/21/08

If I use the formula =A2&"-"&B2 I have to put a (') in front of each date in
column A and B otherwise it comes out as unformatted numbers and I can't use
the format to date to fix it.

Merge two cells with dates to create a date range
 

Thank you if worked perfect.

"David Biddulph" wrote:

=TEXT(A2,"m/dd/yy")&"-"&TEXT(B2,"m/dd/yy")
but please don't merge cells.
Concatenating the contents is fine, but merging cells causes countless
problems (as the archives of the group will show).
--
David Biddulph

"Need Letters in the Columns"
wrote in message
...
Hello, I would like to Merge to cells with dates to create a date range
example

A B c
dstartdate denddate Date Range

8/25/2008 9/21/2008 8/25/09-9/21/08

If I use the formula =A2&"-"&B2 I have to put a (') in front of each date
in
column A and B otherwise it comes out as unformatted numbers and I can't
use
the format to date to fix it.

Merge two cells with dates to create a date range
 

Thank you it worked perfect.
"Sheeloo" wrote:

Use
=text(A1,"mm/dd/yyyy") & "-" & text (B1,"mm/dd/yyyy")

Text() will convert the dates to text and then concatenate
"Need Letters in the Columns" wrote:

Hello, I would like to Merge to cells with dates to create a date range example

A B c
dstartdate denddate Date Range

8/25/2008 9/21/2008 8/25/09-9/21/08

If I use the formula =A2&"-"&B2 I have to put a (') in front of each date in
column A and B otherwise it comes out as unformatted numbers and I can't use
the format to date to fix it.

Merge two cells with dates to create a date range
 

Thank you it worked perfect.

"Gord Dibben" wrote:

=TEXT(A2,"mm/dd/yy")&" - "&TEXT(B2,"mm/dd/yy")


Gord Dibben MS Excel MVP

On Tue, 27 Jan 2009 12:51:02 -0800, Need Letters in the Columns
wrote:

Hello, I would like to Merge to cells with dates to create a date range example

A B c
dstartdate denddate Date Range

8/25/2008 9/21/2008 8/25/09-9/21/08

If I use the formula =A2&"-"&B2 I have to put a (') in front of each date in
column A and B otherwise it comes out as unformatted numbers and I can't use
the format to date to fix it.

Merge two cells with dates to create a date range
 

You're welcome - thanks for taking the trouble to feed back.

Pete

On Jan 28, 2:35*pm, Need Letters in the Columns
wrote:
Thank you it worked perfect.