Adding TEXT in front of a DATE formula

[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

 

[Dan E]

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

 

[Peo Sjoblom]

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

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




Regards,

Peo Sjoblom

 

[Rich Wallach]

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

 

[Michael Bednarek]

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

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

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

 

[RayD]

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.

 

[RayD]

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