Adding TEXT in front of a DATE formula

  • Thread starter Thread starter RayD
  • Start date Start date
R

RayD

Hello everybody,

Is it possible to add text in front?
I am not getting there with this setup.
Can someone help?

=LEFT&"Date Printed:"&TODAY()

Thanks
 
Ray,

="Date Printed: " & TODAY()

Note this will show up as something like:
Date Printed: 37903
Probably not what you wanted. But, you can use the
TEXT function to format the date...

="Date Printed: " & TEXT(TODAY(), "MMMM DD, YYYY")
Date Printed: October 9, 2003

="Date Printed: " & TEXT(TODAY(), "MM/DD/YYYY")
Date Printed: 10/09/2003

etc...

Dan E
 
You can certainly combine text and a date but since you are using TODAY() it
will always
be printed on today's date.. Here's a workaround, first turn on iterations
under tools>options>calculations, leave a column empty, in an adjacent
column
use this formula (assume column A is empty and B is the column we are using)

=IF(A2="","","Date Printed "&TEXT(IF(B2="",TODAY(),B2),"dd/mm/yyyy"))

copy down, now when you print it just put something in A's adjacent cell

If you really wants today's date every time you open the wb you can use

=:Date Printed "&TEXT(TODAY(),"dd/mm/yyyy")




Regards,

Peo Sjoblom
 
You just need to format the date as text:

="Date Printed: " & TEXT(TODAY(),"mm/dd/yy")

Also, the LEFT function is meant to return the first x
characters in a text string where x is the number of
characters to return. It doesn't set alignment.
Hope that helps,
Rich
 
Is it possible to add text in front?
I am not getting there with this setup.
Can someone help?

=LEFT&"Date Printed:"&TODAY()
Click to expand...

What's the LEFT supposed to do? Try this:
="Date Printed: "&TEXT(TODAY(),"yyyy-mmm-dd (ddd)")
or whatever format takes your fancy.
 
Many thanks Michael,

That work very well....



What's the LEFT supposed to do? Try this:
="Date Printed: "&TEXT(TODAY(),"yyyy-mmm-dd (ddd)")
or whatever format takes your fancy.
Click to expand...
 
Super information from everybody -- THANKS


Ray,

="Date Printed: " & TODAY()

Note this will show up as something like:
Date Printed: 37903
Probably not what you wanted. But, you can use the
TEXT function to format the date...

="Date Printed: " & TEXT(TODAY(), "MMMM DD, YYYY")
Date Printed: October 9, 2003

="Date Printed: " & TEXT(TODAY(), "MM/DD/YYYY")
Date Printed: 10/09/2003

etc...

Dan E
Click to expand...
 
Back
Top