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

[Guest]

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.

 

[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

 

[Guest]

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

 

[Guest]

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

 

[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

 

[Guest]

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

 

[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