Dates & Times in Excel

  • 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

  • Answer to Question 1


    Question 2, don't know, sorry!

    Good Luck



    Good Luck!

    Ray :nana:

  • Hi,

    Current date...


    Current day...

    =today() and format cell as "dddd"


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!