Dates & Times in Excel

Answer to Question 1

Today()

Question 2, don't know, sorry!

Good Luck

Ray

Quote from slick225

Hello, I'm new to the board, I've used Excel for years but I'm currently in a position where I need to use several formulas in excel for reporting to save myself some keystrokes. Thanks in Advance for any help.

Question 1: What is the command to get the current date w/o timestamp, to appear in a cell? (I've used '=NOW()' , but this formula includes the timestamp.

Question 2: Is there a formula that will display the current day?

Again, Thanks in Advance

Display More

Hi,

Current date...

=today()

Current day...

=today() and format cell as "dddd"

Cheers!

Hi,

Assuming you have entered =Today() in cell A1 then enter this is B1

=TEXT(WEEKDAY(A1),"dddd")

HTH

Re: Dates & Times in Excel

ctrl+semicolon enters the system date, ctrl+colon enters the system time.