Thread: Dates in a text string?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
seve
 
Posts: n/a
Default Dates in a text string?
I found the answer...just had to search on the right words....

This works


=CONCATENATE(TEXT(F1+7,"mm/dd"), " - ",(TEXT(F2+7,"mm/dd")))

Reply With QuoteReply With Quote