Dismiss Notice
You are browsing this site as a guest. It takes 2 minutes to CREATE AN ACCOUNT and less than 1 minute to LOGIN

How To Get The Current Date and Time In Excel

Discussion in 'Tech, Gadgets & Science Forum' started by X-PASTER, Jul 12, 2011.

  1. X-PASTER

    X-PASTER Moderator

    #1
    Jul 12, 2011
    Joined: Feb 12, 2007
    Messages: 11,651
    Likes Received: 75
    Trophy Points: 145
    How To Get The Current Date and Time In Excel

    Question:

    Is there a way to get the date and time automatically by creating a formula?

    Answer:
    This is an easy one - use =NOW() to get the current date and time. Use =TODAY() to get the current date.

    Press CTRL + ; (utapata Tarehe, date)

    Press CTRL+ shft + : (Utapata Muda Saa, time)

    Pia kuna njia hizi hapa unaweza kuzitumia

    [TABLE="class: grid"]
    [TR]
    [TD]=NOW()
    [/TD]
    [TD] date & time (only down to hh:mm:ss)*[/TD]
    [/TR]
    [TR]
    [TD]=Now()[/TD]
    [TD]show date if formatted for date*[/TD]
    [/TR]
    [TR]
    [TD]=Now()[/TD]
    [TD]show time if formatted for time*
    [/TD]
    [/TR]
    [TR]
    [TD]=int(Now())[/TD]
    [TD]date only, must be formatted for date*[/TD]
    [/TR]
    [TR]
    [TD]=mod(Now(),1) [/TD]
    [TD]time only, must be formatted for time*
    [/TD]
    [/TR]
    [/TABLE]


    * See "Number format codes for dates and times" in help.
    example of time format: hh:mm:ss
    examples of date or custom date format: mm/dd/yyyy and dddd mmmm dd, yyyy


    Excel trickery:
    if you enter the formula =NOW() into a cell and then hit F9 (calculate) without hitting Enter, it will convert the unentered formula to a constant without formatting of it's own, so you should format the column.


    For More amazing tricks bonyeza viungo hivi: dmcritchie | support.microsoft | exceldigest
     
  2. Lambardi

    Lambardi JF-Expert Member

    #2
    Jul 12, 2011
    Joined: Feb 7, 2008
    Messages: 7,563
    Likes Received: 2,065
    Trophy Points: 280
    Kuna ile ingine ya kubadilisha tarehe yenyewe kila siku kwenye excel doc!!tukumbushe wadau
     
  3. X-PASTER

    X-PASTER Moderator

    #3
    Jul 12, 2011
    Joined: Feb 12, 2007
    Messages: 11,651
    Likes Received: 75
    Trophy Points: 145
    In excel type =Today()

    In Word No programming required, just click Insert a date field in your document.
     
  4. fxb

    fxb Senior Member

    #4
    Jul 14, 2011
    Joined: Jun 22, 2011
    Messages: 124
    Likes Received: 0
    Trophy Points: 33
    Waoo hapa nimepata darasa asanteni
     
  5. ndetichia

    ndetichia JF-Expert Member

    #5
    Jul 14, 2011
    Joined: Mar 18, 2011
    Messages: 27,534
    Likes Received: 120
    Trophy Points: 160
    kudos x pastor
     
Loading...