View Single Post
  #5   Report Post  
JE McGimpsey
 
Posts: n/a
Default

one way:

=TEXT(A1,"m/d/yy") & TEXT(B1,"m/d/y")

In article ,
"Lisa" wrote:

I am trying to concantenate 2 dates field together like 1/1/04 & 12/31/04
into 1 field showing 1/1/04 - 12/31/04 but not able to use the concatenate
function for it convert to data to a number. Any help is appreciated.