• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 249
  • Last Modified:

Excel Today

According to Microsoft, "The TODAY function returns the serial number of today's date based on your system clock and does not include the time. The NOW function returns the serial number of today's date and includes the time."

This is from http://support.microsoft.com/kb/214094

See attached.

How can I adjust this so I JUST get the date?

Richard Korts
Richard Korts
1 Solution
Change the cell format. It seems that someone had put the =NOW() in the cell and then changed it to =TODAY() keeping the cell format as Custom m/d/yyyy h:mm
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now