Combine text and today's date in a cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to add today's date and text in a cell? Can I please have the
formula?
 
Try something like this:

="Today is: "&TEXT(TODAY(),"MMMM DD, YYYY")

If today is August 29, 2006
that formula returns: Today is August 29, 2006

Does that help?
***********
Regards,
Ron

XL2002, WinXP
 
Couple of examples

="this file was created on: " &TEXT(Creadate(),"mmmm d" &"," &"yyyy")

=B1& " " &TEXT(C1,"mmmm d" &"," &"yyyy") where B1 contains text

And one more to have text, date and a an amoun in the cell.

="Payment due " &TEXT(H15,"mmmm, d yyyy") & " " & TEXT(I15,"$#,##0.00")


Gord Dibben MS Excel MVP
 
And this returns what?

Perhaps you left something out?


Gord Dibben MS Excel MVP
 
Thank you. It worked.


Ron Coderre said:
Try something like this:

="Today is: "&TEXT(TODAY(),"MMMM DD, YYYY")

If today is August 29, 2006
that formula returns: Today is August 29, 2006

Does that help?
***********
Regards,
Ron

XL2002, WinXP
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Searching the formula (not the value) for a text string 1
Formula for Dates and CF Colour then convert to Text 3
Showing Day and Date in the same Cell 4
Excel Date Count 2
Excel Macro to automatically go to the right of the last colored cell 0
Comparison of columns using Conditional Formatting 3
Combining multiple formulas in one cell 5
How do I subtract todays date from range of dates 1

Back
Top