TEXT(date)?

J

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
 
G

Gary''s Student

Your answer is in your question!!

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