How To Get The Current Date and Time In Excel

[X-PASTER]

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

 

[Lambardi]

Kuna ile ingine ya kubadilisha tarehe yenyewe kila siku kwenye excel doc!!tukumbushe wadau

 

[X-PASTER]

Kuna ile ingine ya kubadilisha tarehe yenyewe kila siku kwenye excel doc!!tukumbushe wadau

In excel type =Today()

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

 

[fxb]

Waoo hapa nimepata darasa asanteni

 

[ndetichia]

kudos x pastor