View Single Post
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

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

--

HTH

RP
(remove nothere from the email address if mailing direct)


"jadams-bellevue" wrote in
message ...
How do I concatendate dates from several cells into one cell, while
maintaining the date format? When I have tried, it converts the dates to
serial numbers instead of the actual date. Is there a better way to

combine
these cells - possibly using VB If statements??? Any ideas either way is
appreciated.