CALC 1 Home Documentation Home Contact

DAYS Function Calculator

Calculates the actual number of days between dates.

Also see the Date Form Calculator. It will calculate the days between two dates, or a date given the days between on one date using date pickers.

screenshot

 

Formula: days(DateS, DateE)

DateS: The start date in YYYYMMDD format.

DateE: The end date in YYYYMMDD format.

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?

 

Value Keystrokes Display Description
70228 DateS 70,228.0000 Stores the DateS value.
80229 DateE 80,229.0000 Stores the DateE value.
  Δ Days 366.00 Calculates the 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