Ask Your Question
0

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

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

Darth Barney gravatar image

updated 2018-05-09 21:06:17 +0100

LibreTraining 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
3

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

JohnSUN gravatar image

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

1) Use simple formula

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

image description

Or

2) Use user-defined format of cell image description

edit flag offensive delete link more

Comments

Awesome! Thank you.

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

Question Tools

1 follower

Stats

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

Seen: 95 times

Last updated: May 09 '18