Concatenate for Numbers?

  • Thread starter Thread starter Michelle
  • Start date Start date
M

Michelle

In column A of my spreadsheet is Start Date (01/01/04),
Column B is End date (01/10/04). Each rows contains
different start and end dates. I am attempting to tie
these two together without retyping 300 rows of data. I
need a single column for date range (01/01/04 - 01/10/04).

I attempted to use Concatenate, however, it only works
with text. Is there a formula that I can use to join
these two together.

Your assistance is apprecitated.

Michelle
 
Hi Michelle,

Try,

=TEXT(A1,"mm/dd/yy")&" - "&TEXT(B1,"mm/dd/yy")

Hope this helps!
 
Hi
use TEXT for this. e.g.
=TEXT(A1,"mm-dd-yyyy") & " - " & TEXT(B1,"mm-dd-yyyy")
 
You must log in or register to reply here.

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

Similar Threads

Excel Formula Help! 2
COUNT BETWEEN A SPECIFIC DATE RANGE 4
Formula ? 4
Start and End date 2
Total 1
macro help 1
Fals Result in IF Formula 1
Date separator 1

Back
Top