How to add 12 hours to TODAY()

[Scott_Nesbitt]

I am trying to set a default DateTime value to today at noon, but am having a bit of difficulty.

Per the sixth example in this article I thought this would work:

TIME(TODAY()) : 12:00:00 PM

However, it is yielding 12/30/1899 12:00:00 AM

Have tried searching the docs and this forum, no luck.  Any suggestions? 

[lynchk21 · Accepted solution]

Does this work?

DATE(TODAY())&" "&"12:00:00"

[Scott_Nesbitt]

It worked!  Thanks for the clever solution.