There are a number of date functions available in Excel. Depending on your needs, you can use a date function in Excel to return the current date, the current time, or the day of the week. This article covers using the most commonly used date functions used in Excel: =TODAY() and =NOW()
=TODAY()
This function returns the current date. To display the date in a different format than the default:
1.Click on Format > Cells in the menus to bring up the Format Cells dialog box.
2.Click on the Number tab.
3.Select Date in the Category window.
4.Pick from the available formats in the Type window.
=NOW()
This function returns both the current date and time. To change the display to show just the date, follow the steps for the =TODAY() function above.
To change the display to show just the time:
1.Click on Format > Cells in the menus to bring up the Format Cells dialog box.
2.Click on the Number tab.
3.Select Time in the Category window.
4.Pick from the available formats in the Type window.
Thanks : about.com
ไม่มีความคิดเห็น:
แสดงความคิดเห็น