| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combine text and today's date in a cell
Is it possible to add today's date and text in a cell? Can I please have the
formula? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Combine text and today's date in a cell
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 "Sheila" wrote: Is it possible to add today's date and text in a cell? Can I please have the formula? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Combine text and today's date in a cell
=concatenate(TODAY(),"MMMM DD, YYYY")
-- Brevity is the soul of wit. "Ron Coderre" wrote: 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 "Sheila" wrote: Is it possible to add today's date and text in a cell? Can I please have the formula? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Combine text and today's date in a cell
And this returns what?
Perhaps you left something out? Gord Dibben MS Excel MVP On Tue, 29 Aug 2006 12:14:02 -0700, Dave F wrote: =concatenate(TODAY(),"MMMM DD, YYYY") |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Combine text and today's date in a cell
Thank you. It worked.
"Ron Coderre" wrote: 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 "Sheila" wrote: Is it possible to add today's date and text in a cell? Can I please have the formula? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Combine text and today's date in a cell
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 On Tue, 29 Aug 2006 11:44:02 -0700, Sheila wrote: Is it possible to add today's date and text in a cell? Can I please have the formula? |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Combine text and today's date in a cell
On Tue, 29 Aug 2006 12:23:03 -0700, Gord Dibben <gorddibbATshawDOTca wrote:
and a an amoun in the cell. How about "and an amount in the cell"<g Gord Gord Dibben MS Excel MVP |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text & Date in the same Cell??? | Excel Worksheet Functions | |||
| Hyperlinks to a date cell | Excel Discussion (Misc queries) | |||
| converting text in cell to a date time | Excel Worksheet Functions | |||
| Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
| Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
Hybrid Mode
