Which excel function is used to calculate the current date and time?

Discussion in 'Computer Questions, Issues & Security' started by Dexterbell, Dec 18, 2013.

  1. Dexterbell

    Dexterbell
    uix_expand uix_collapse
    Member

    Joined:
    Dec 17, 2013
    Messages:
    205
    Likes Received:
    2
    Which function is used to calculate the current date and time?
    1. Date ()
    2. Today ()
    3. Now ()
     
  2. andrewc

    andrewc
    uix_expand uix_collapse
    Member

    Joined:
    Nov 12, 2013
    Messages:
    175
    Likes Received:
    21
    That's simple! 3. Now()
     
  3. jeremy

    jeremy
    uix_expand uix_collapse
    Member

    Joined:
    Dec 19, 2013
    Messages:
    38
    Likes Received:
    2
    Dexterbell already posted the answer, we just need to try out all 3 methods to get the correct answer.
     
  4. anandshah

    anandshah
    uix_expand uix_collapse
    Member

    Joined:
    Sep 18, 2013
    Messages:
    106
    Likes Received:
    0
    Yes, the is now().
     
  5. marriott

    marriott
    uix_expand uix_collapse
    Member

    Joined:
    Sep 20, 2013
    Messages:
    400
    Likes Received:
    11
    Now() function is used to calculate the current date and time.
     
  6. bmwillsmith

    bmwillsmith
    uix_expand uix_collapse
    Member

    Joined:
    Jan 23, 2014
    Messages:
    380
    Likes Received:
    10
    the simple code for excel to know date and time exactly just type this code in a cell:
    Then you can get exact date.
     
  7. sudhakar1

    sudhakar1
    uix_expand uix_collapse
    Member

    Joined:
    Sep 9, 2013
    Messages:
    150
    Likes Received:
    6
    Hi,
    This format is like excel for one row A and one column 2 Now set the syntax an DAY(serial_number) its example DAY(A2) now show the result
     
  8. shaadisankalp

    shaadisankalp
    uix_expand uix_collapse
    Member

    Joined:
    Jan 28, 2014
    Messages:
    49
    Likes Received:
    1
    =now() is used for the showing the Date and Time......
     
  9. kobyparsons

    kobyparsons
    uix_expand uix_collapse
    Member

    Joined:
    Jan 8, 2014
    Messages:
    83
    Likes Received:
    3
    Use NOW, to Calculate the current Date and Time, on your computer or Exel.
     
  10. Ankursood

    Ankursood
    uix_expand uix_collapse
    New Member

    Joined:
    Jan 29, 2014
    Messages:
    2
    Likes Received:
    0
    =today() is used the for showing the drtail..
     
  11. Aiplabro

    Aiplabro
    uix_expand uix_collapse
    Member

    Joined:
    Jan 30, 2014
    Messages:
    65
    Likes Received:
    0
    Its Now(). You can use this for calculate date and time.
     
  12. marriott

    marriott
    uix_expand uix_collapse
    Member

    Joined:
    Sep 20, 2013
    Messages:
    400
    Likes Received:
    11
    its NOW() function which is used to calculate Current date and Time....
     

Share This Page