Date related functions are listed in alphabetical order below.
30/360
Calculates the number of days between two dates using the 30/360 day count basis (12 months x 30 days).
Input form:<from date> 30/360 <to date>
where dates are specified with reference to the zero day value. In practice, you can use the [DATE]
key to input date values.
Example: Find the number of days between May 16th, 2001 and January 9th, 2005 using the 30/360
basis. Assume that you enter dates in M-D-Y format.
5 [DATE] 16 [DATE] 2001
[30/360]
1 [DATE] 9 [DATE] 2005
[ENTER]
Displays: 1313
30E/360
Calculates the number of days between two dates using the 30E/360 day count basis. This function is
identical to 30/360, except that European rules are used for the month of February.
DATE
Use the [DATE] key to enter a date and optional time. The input is converted automatically to a day
calendar value. For most users, the date format will automatically be set to their preferred notation.
Otherwise it will default to Month-Day-Year (M-D-Y).
Example: Key in May 16th, 2001. Assume that you enter dates in M-D-Y format.
5 [DATE] 16 [DATE] 2001
[ENTER]
Displays: 730621 (Rata Die)
Also use the [DATE] key to convert a numerical value to a date representation.
For example:
730621
[DATE]
Displays: 05/16/2001
For more information, see Calculating with Dates.
DOW
Calculates the corresponding day of week, given a date input, where Monday always has a value of 1.
Example: What day will it be on March 17th, 2029?
[DOW]
3 [DATE] 17 [DATE] 2029 (March 17, 2029)
[ENTER]
Displays: 6
The value of 6 represents Saturday. The number value for Sunday may be either 0 or 7, depending up your
setting for the first day of the week in the Options Window.
DOY
Calculates the corresponding day of the year, given a date input, where 1 is the first day of the applicable
year.
TODAY
Returns the current date and time from the PC clock. It may return either your local time or Universal Time,
as configured in the Options Window.
Example: What date will it be in 321 days from now?
[TODAY] (today's date & time from PC clock)
[+]
321
[ENTER]
Displays: 2455892.142... (depends on current time)
and pressing...
[DATE] Displays: 11/26/2011 +15:25:51.
For more information, see Calculating with Dates.
WKNO
Given a date input, WKNO returns the corresponding week of the year according to the ISO8601 Standard, which
defines the first week of the year as being the one which contains the 4th of January. The result may be
between 1 and 52, or 53 for leap years and is affected by the "Week Start" setting in the Options Window.
See also: Calculating with Dates
|