Create Sentence using other cells

We would like to create a sentence using other cells. Example: In one cell we have date “1-Jan-2012” another cell we have “5-Jan-2012”. We would like to create a sentence in another cell like this “We will be away from 1-Jan-2012 and back on 5-Jan-2012”. Would anyone know how to do this?

R

CB

If your first date is in cell A1, and the 2nd in cell B1 then in another cell try:

="We will be away from " & TEXT(A1,"dd-mmm-yyyy") & " and back on " & TEXT(B1,"dd-mmm-yyyy")

Thanks All, works perfectly. Thanks for your help

R

CB