Microsoft Office Tutorials and References
In Depth Information
Returns the date that represents the indicated number of months
before or after the start date
EDATE*
Returns the date of the last day of the month before or after a
specified number of months
EOMONTH*
ISOWEEKNUM***
Returns the ISO week number for a date
MONTH
Returns the month for a given date
NETWORKDAYS*
Returns the number of whole work days between two dates
NETWORKDAYS.INTL** An international version of the NETWORKDAYS function
NOW
Returns the current date and time
TODAY
Returns today's date
WEEKDAY
Returns the day of the week (expressed as a number) for a date
WEEKNUM*
Returns the week number of the year for a date
WORKDAY*
Returns the date before or after a specified number of workdays
WORKDAY.INTL**
An international version of the WORKDAY function
YEAR
Returns the year for a given date
Returns the year fraction representing the number of whole days
between two dates
YEARFRAC*
* 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:
=TODAY()
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