X-PASTER
JF-Expert Member
- Feb 12, 2007
- 11,604
- 1,858
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