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

K

Ken Janowitz

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.
 
B

Bernard Liengme

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
 
B

bpeltzer

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

John Michl

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
 
J

John Michl

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
 
Top