Merge two cells with dates to create a date range

  • Thread starter Need Letters in the Columns
  • Start date

N

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.
 
Ad

Advertisements

P

Pete_UK

Try it this way:

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

then copy it down.

Hope ths helps.

Pete
 
S

Sheeloo

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

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

Need Letters in the Columns

Thank you it worked perfect.

Pete_UK said:
Try it this way:

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

then copy it down.

Hope ths helps.

Pete
 
N

Need Letters in the Columns

Thank you it worked perfect.
Sheeloo said:
Use
=text(A1,"mm/dd/yyyy") & "-" & text (B1,"mm/dd/yyyy")

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

Advertisements

Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top