How do i concatenate two date fields.

  • Thread starter Thread starter J9
  • Start date Start date
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 do I concatenate two date fields 2
need to convert microsoft date to yyyymmdd 2
Rich Text Format 0
Access MS Access Concatenate a date and text field 16
Excel with Concatenate does not format date correctly 1
concatenate 5
Concatenate 6
Looking for a Date forming function 3

Back
Top