TEXT(date)?

[JMF]

As you know, the function

=DATEVALUE("8/22/2008")

produces a date from its corresponding text representation.

I want to go the OTHER way. That is, I want to take a date and produce its
text representation (I'll settle for any reasonable format).

How might I go about doing that?

Thanks,

John

 

[Guest]

Your answer is in your question!!

try:
=TEXT(TODAY(),"dd-mm-yy") or any other reasonable date-style format

 

[JMF]

Well what do you know! I guessed right without even knowing it!

Thanks!

John