# 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-PASTERModerator

#1
Jul 12, 2011
Joined: Feb 12, 2007
Messages: 11,652
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?

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. ### LambardiJF-Expert Member

#2
Jul 12, 2011
Joined: Feb 7, 2008
Messages: 7,948
Trophy Points: 280
Kuna ile ingine ya kubadilisha tarehe yenyewe kila siku kwenye excel doc!!tukumbushe wadau

3. ### X-PASTERModerator

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

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

4. ### fxbSenior Member

#4
Jul 14, 2011
Joined: Jun 22, 2011
Messages: 124