How do I combine 2 sets of dates using concatenate function?

  • Thread starter Thread starter JunIX
  • Start date Start date
J

JunIX

Sample:

Cell A1 26-Mar-08
Cell A2 25-Apr-08

to get "26-Mar-08 to 25-Apr-08"
 
Try this:

=TEXT(A1,"dd-mmm-yy")&" to "&TEXT(A2,"dd-mmm-yy")

Hope this helps.

Pete
 
Oops, that should have been

= TEXT(A1,"dd-mmm-yyyy") & " to " & TEXT(A2,"dd-mmm-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

Calculate End Date Using Start Date and No. of Days excluding specific days. 0
When building a chart Dates are been included that are not in thedate range 1
To Calculate the qty b/w two dates 6
Text lookup array and match specific data 3
Reducing duplicate courses to totals of each day 3
IF condition using GMT and BST times 4
How to write XIRR formula on excel using different Year basis than 365. 5
Count Records 11

Back
Top