Help with the CONCATENATE formula

[tech1NJ]

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.

 

[Per Jessen]

Hi

Use the TEXT function to format the date as desired.

="Your Text "&TEXT(A1;"mmm. dd, yyyy")

Hopes this helps

 

[Luke M]

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

 

[bapeltzer]

The concatenate will pull in the value but not the format. You can dictate
the format using the text function:
="Your service will expire on " & text(Sheet2!D32,"Mmmm d, yyyy") etc

 

[Deriv001]

If you convert the date to a text format using the following formula it may
show properly in the concatenate formula. Refernence the cell with the text
formula in your concatenate formula (no need to paste special as "value").

=TEXT(F1,"mmmmmmmm dd, yyyy") were F1 is the date you want included.

 

[tech1NJ]

This worked. Thanks
--
tech1NJ

The concatenate will pull in the value but not the format. You can dictate
the format using the text function:
="Your service will expire on " & text(Sheet2!D32,"Mmmm d, yyyy") etc