How do I use the concatenate function to add a date into a sentenc
 

When I try to use the concatenate function to add a date from a cell into a
sentence I get the numerical date equivalent, not the date itself.

How do I use the concatenate function to add a date into a sentenc
 

In my test: A1 has the formula =TODAY()
If, in A2, I use the formula ="Today is "& A1 then I get the serial number
as you do
If I use ="Today is "& TEXT(A1,"dd/mm/yyyy") the result is what I want
If you are in US you would use ="Today is "& TEXT(A1,"mm/dd/yyyy")

best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Ken Janowitz" <Ken wrote in message
...
When I try to use the concatenate function to add a date from a cell into
a
sentence I get the numerical date equivalent, not the date itself.

How do I use the concatenate function to add a date into a sentenc
 

Embed the date inside a TEXT function to supply formatting:
="Today is " & text(today,"Mmm dd"))

"Ken Janowitz" wrote:

When I try to use the concatenate function to add a date from a cell into a
sentence I get the numerical date equivalent, not the date itself.

How do I use the concatenate function to add a date into a sentenc
 

="Your birthday is on "&text(cell with date,"mm/dd/yyyy")

"Ken Janowitz" wrote:

When I try to use the concatenate function to add a date from a cell into a
sentence I get the numerical date equivalent, not the date itself.

How do I use the concatenate function to add a date into a sentenc
 

You need to convert the date to text and format it. Put the date in
cell A1 and try this:

="The date is "&TEXT(A1,"mm/dd/yyyy")
or
="The date is "&TEXT(A1,"[$-F800]dddd, mmmm dd, yyyy")

That should do it.

John
www.JohnMichl.com

How do I use the concatenate function to add a date into a sen
 

I still can't get my sentance to work. Here is what I am trying to do:

Of the {cella} of unassigned carriers, {cellb} had pickups scheduled on
{today's date} or earlier.

Cell refers to a cell location where I want to get information: calla is a
number, cellb is a number, today's date is today.

In your example you had too many () which weren't matched.

Thanks,

Ken Janowitz

"bpeltzer" wrote:

Embed the date inside a TEXT function to supply formatting:
="Today is " & text(today,"Mmm dd"))

"Ken Janowitz" wrote:

When I try to use the concatenate function to add a date from a cell into a
sentence I get the numerical date equivalent, not the date itself.

How do I use the concatenate function to add a date into a sen
 

This should work. You can change the formatting in the two TEXT
functions to match whatever formatting is desired. Note this should
all be typed on one line. I broke it up to make it easier to read on
line.

="Of the " & text(A1,"#,###") &
" of unassigned carriers, " & B1 &
" had pickups scheduled on " &
TEXT(NOW(),"dd/mm/yyyy") & " or earlier."

- John