CALC 1 Home Documentation Home Contact

DAYS360 Function Calculator

Calculates the number of days between dates using s 360 year for NASD, EURO and spreadsheet compatible methods.

 

screenshot

 

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

Date Entry

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.

Date Entry Shortcuts

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.

 

Example 1

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.

Example 2

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.

 

Example 3

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:

Wikipedia 360-Day Calendar