X-PASTER
JF-Expert Member
- Feb 12, 2007
- 11,610
- 1,810
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
| =NOW() | date & time (only down to hh:mm:ss)* |
| =Now() | show date if formatted for date* |
| =Now() | show time if formatted for time* |
| =int(Now()) | date only, must be formatted for date* |
| =mod(Now(),1) | time only, must be formatted for time* |
* 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
