Microsoft Office Tutorials and References
In Depth Information
Date-Related Worksheet Functions
Two-digit years between 00 and 29 are interpreted as 21st-century dates, and two-digit
years between 30 and 99 are interpreted as 20th-century dates. For example, if you enter
12/15/28 , Excel interprets your entry as December 15, 2028. But if you enter 12/15/30 ,
Excel sees it as December 15, 1930, because Windows uses a default boundary year of 2029.
You can keep the default as is or change it via the Windows Control Panel. In the Region
dialog box (or the equivalent if you’re using Windows Server), click the Additional Settings
button to display the Customize Format dialog box. Select the Date tab and then specify a
different year.
16
The best way to avoid any surprises is to simply enter all years using all four digits for the year.
Date-Related Worksheet Functions
Excel has quite a few functions that work with dates. These functions are accessible by
choosing Formulas
Function Library
Date & Time.
Table 16.4 summarizes the date-related functions available in Excel.
TABLE 16.4 Date-Related Functions
Function
Description
DATE
Returns the serial number of a particular date
DATEVALUE
Converts a date in the form of text to a serial number
DAY
Converts a serial number to a day of the month
DAYS***
Returns the number of days between two dates
DAYS360
Calculates the number of days between two dates based on a
360-day year
EDATE*
Returns the serial number of the date that represents the
indicated number of months before or after the start date
EOMONTH*
Returns the serial number of the last day of the month before or
after a specifi ed number of months
ISOWEEKNUM***
Returns the ISO week number for a date
MONTH
Converts a serial number to a month
NETWORKDAYS*
Returns the number of whole work days between two dates
NETWORKDAYS.INTL**
An international version of the NETWORKDAYS function, which
allows nonstandard weekend days
Continues
 
Search JabSto ::




Custom Search