Thread: How do I combine 2 sets of dates using concatenate function?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
  
Posts: 8,856
Default How do I combine 2 sets of dates using concatenate function?
Try this:

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

Hope this helps.

Pete

On Aug 22, 1:10*am, JunIX wrote:
Sample:

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

to get "26-Mar-08 to 25-Apr-08"

Reply With QuoteReply With Quote