Merge two cells with dates to create a date range

[Need Letters in the Columns]

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.

 

[Pete_UK]

Try it this way:

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

then copy it down.

Hope ths helps.

Pete

 

[Sheeloo]

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

Text() will convert the dates to text and then concatenate

 

[Gord Dibben]

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


Gord Dibben MS Excel MVP

 

[Need Letters in the Columns]

Thank you it worked perfect.

Try it this way:

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

then copy it down.

Hope ths helps.

Pete

 

[Need Letters in the Columns]

Thank you it worked perfect.

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]

Thank you it worked perfect.

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


Gord Dibben MS Excel MVP

 

[Pete_UK]

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

Pete