Microsoft Office Tutorials and References
In Depth Information
Returns the date that represents the indicated number of months
before or after the start date
Returns the date of the last day of the month before or after a
specified number of months
Returns the ISO week number for a date
Returns the month for a given date
Returns the number of whole work days between two dates
NETWORKDAYS.INTL** An international version of the NETWORKDAYS function
Returns the current date and time
Returns today's date
Returns the day of the week (expressed as a number) for a date
Returns the week number of the year for a date
Returns the date before or after a specified number of workdays
An international version of the WORKDAY function
Returns the year for a given date
Returns the year fraction representing the number of whole days
between two dates
* In versions prior to Excel 2007, this function is available only when the Analysis ToolPak add-in is installed.** A function intro-
duced in Excel 2010*** A function introduced in Excel 2013
Displaying the current date
The following function displays 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 updated whenever the worksheet is calculated. For ex-
ample, if you enter either of the preceding formulas into a worksheet, the formula displays the current date.
When you open the workbook tomorrow, though, it will display the current date for that day (not the date when
you entered the formula).
Search JabSto ::

Custom Search