How do i concatenate two date fields.

J

J9

Dear Excel

How do i concatenate two date fields with out losing the date format?

Thanks
 
R

Rick Rothstein

Use the TEXT function. For example...

=TEXT(A1,"mm/dd/yyyy")&" - "&TEXT(A2,"mm/dd/yyyy")

where A1 and A2 are assumed to hold your dates and that the format you want
your dates in are mm/dd/yyyy.
 

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

How to have two tables on same line? 1
How to create a bubble chart with more than 2 variables. 0
Combo or list box 0
How to automate update on weekly reports spreadsheet 0
Countdown macro - display settings 2
MS Project Center-Autolink column fields 0
How do I concatenate two date fields 2
Project Status Date 1

Top