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.
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
Returns the serial number of a particular date
Converts a date in the form of text to a serial number
Converts a serial number to a day of the month
Returns the number of days between two dates
Calculates the number of days between two dates based on a
360-day year
Returns the serial number of the date that represents the
indicated number of months before or after the start date
Returns the serial number of the last day of the month before or
after a specifi ed number of months
Returns the ISO week number for a date
Converts a serial number to a month
Returns the number of whole work days between two dates
An international version of the NETWORKDAYS function, which
allows nonstandard weekend days
Search JabSto ::

Custom Search