Calculates the number of days between dates using s 360 year for NASD, EURO and spreadsheet compatible methods.
Formula: days360(DateS, DateE, mthd)
DateS: The start date in YYYYMMDD format.
DateE: The end date in YYYYMMDD format.
mthd: The method to use. 0=spreadsheet, 1=euro, -1=nasd
CALC 1 uses the ISO 8601 YYYYMMDD format for entering dates. This is a common date format that most users around the world are familiar with.
For example, April 28, 2004 is entered as 40428. June 4, 2018 is entered as 180604.
If you omit the first two years (the century) of YYYY, CALC 1 will use the current century, 20. This is a common truncated representation.
If you omit the entire YYYY, CALC 1 will use the current year.
Calculate how many days there are between 2007-02-28 and 2008-02-29 using the spreadsheet method.
Value | Keystrokes | Display | Description |
---|---|---|---|
70228 | DateS | 70,228.0000 | Stores the DateS value. |
80229 | DateE | 80,229.0000 | Stores the DateE value. |
0 | mthd | 0.0000 | Stores the mthd value. |
Δ Days | 359.00 | Calculates the days. |
Calculate how many days there are between 2007-02-28 and 2008-02-29 using the euro method.
These keystrokes assume the values from example 1.
Value | Keystrokes | Display | Description |
---|---|---|---|
1 | mthd | 1.0000 | Stores the mthd value. |
Δ Days | 361.0000 | Calculates days. |
Calculate how many days there are between 2007-02-28 and 2008-02-29 using the nasd method.
These keystrokes assume the values from example 1.
Value | Keystrokes | Display | Description |
---|---|---|---|
-1 | mthd | -1.0000 | Stores the mthd value. |
Δ Days | 360.0000 | Calculates days. |
Note that since the variables, DateS and DateE are entered in YYYYMMDD format that this formula calculator cannot be used to solve for either the start or end date.
Reference: