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.
Formula: days(DateS, DateE)
DateS: The start date in YYYYMMDD format.
DateE: The end date in YYYYMMDD format.
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?
|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.