You'll need to use the TEXT function to force the formatting of inserted
dates. Formula then becomes:

="Your service will expire on "&TEXT(Sheet2!D32,"mmmm dd, yyyy")&". However,
your last preventive maintanence with revalidation was on
"&TEXT(Sheet2!D33,"mmmm dd, yyyy")&"."
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"tech1NJ" wrote:

I would like to CONCATENATE the following phrases on Sheet1!A19 with dates
from Sheet2!D32 and Sheet2!D33 but am having some problems. Please help.

I would like to see the following in Sheet1!A19: Your service will expire on
April 19, 2009. However, your last preventive maintanence with revalidation
was on March 1, 2008.

Problem being displayed is the following: Your service will expire on 39922
and your last preventive maintanence with revalidation was on 39508.

The dates on Sheet2!D32 and Sheet2!D33 are formated for a Date with the
following format - April 19, 2009.
--
tech1NJ