View Single Post
  #3   Report Post  
tjtjjtjt
 
Posts: n/a
Default

Lisa,

The two dates are in A7 and A8 for this example:
=TEXT(A7,"m/d/yyyy")&" - "&TEXT(A8,"m/d/yyyy")

tj

"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.