Ask Your Question

Calc: How do I use text and TODAY() function in same cell with date properly formated?

asked 2018-05-09 21:00:02 +0200

Darth Barney gravatar image

updated 2021-05-07 22:59:25 +0200

Alex Kemp gravatar image

="Date: "&TODAY()

Results in image description

...which I'm assuming is numeric code for today, but I would like to format it as MM/DD/YY as if I were using the TODAY() function without text, which returns today's date in the proper format...

image description image description

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-05-09 21:24:54 +0200

JohnSUN gravatar image

updated 2018-05-09 21:25:21 +0200

1) Use simple formula

="Date is: " & TEXT(TODAY();"MM/DD/YY")

image description


2) Use user-defined format of cell image description

edit flag offensive delete link more


Awesome! Thank you.

Darth Barney gravatar imageDarth Barney ( 2018-05-10 00:07:06 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-05-09 21:00:02 +0200

Seen: 1,892 times

Last updated: May 09 '18