Microsoft Office Tutorials and References
In Depth Information
Displaying the current date
TABLE 16.4 (continued)
Returns the serial number of the current date and time
Returns the serial number of today’s date
Converts a serial number to a day of the week
Returns the week number in the year
Returns the serial number of the date before or after a specifi ed
number of workdays
An international version of the WORKDAY function, which allows
nonstandard weekend days
Converts a serial number to a year
Returns the year fraction representing the number of whole days
between start_date and end_date
* In versions prior to Excel 2007, these functions are available only when the Analysis ToolPak add-in is
** Indicates a function introduced in Excel 2010.
*** Indicates a function introduced in Excel 2013.
Displaying the current date
The following formula uses the TODAY function to display the current date in a cell:
You can also display the date combined with text. The formula that follows, for example,
displays text, such as Today is Tuesday, April 9, 2013 :
="Today is "&TEXT(TODAY(),"dddd, mmmm d, yyyy")
It’s important to understand that the TODAY function is not a date stamp. The function
is updated whenever the worksheet is calculated. For example, if you enter either of the
preceding formulas into a worksheet, the formulas display the current date. And when you
open the workbook tomorrow, they will display the current date (not the date when you
entered the formula), assuming the default Workbook Calculation option, Automatic, is
selected in File
Formulas, under Calculation options.
To enter a date stamp into a cell, press Ctrl+; (semicolon). This action enters the date directly into the cell and
doesn’t use a formula. Therefore, the date won’t change.
Search JabSto ::

Custom Search