Thread: How do I combine 2 sets of dates using concatenate function?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
  
Posts: 3,355
Default How do I combine 2 sets of dates using concatenate function?
=FORMAT(A1,"dd-mmm-yyyy") & " to " & FORMAT(A2,"dd-mmm-yyyy")
--
HTH,
Barb Reinhardt



"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