Tool to make calculation with dates. Date can be computed with additions or subtractions of days, weeks, months or years with a given date.
Calculation with Dates - dCode
Tag(s) : Date and Time
dCode is free and its tools are a valuable help in games, maths, geocaching, puzzles and problems to solve every day!
A suggestion ? a feedback ? a bug ? an idea ? Write to dCode!
The calculation of addition or subtraction of a number of days N to a given date makes it possible to define another date, in the future (or the past) located at an interval of N days.
It is very used for countdowns before an event, or to calculate an age in number of days.
Example: 135 days before the next Olympic Games
dCode locate the day, month and year in a reference calendar and add or subtract the number of days required for the initial date to calculate the new date.
Example: To determine when somebody had/will have 10,000 days, add 10000 days to the date of birth.
Calculation uses the Gregorian Calendar and the Julian one before 1582.
It is possible to get good approximations using the values: 1 week = 7 days, 1 month = 30.4 days (average value), 1 trimester = 91.3 days (average value), 1 year = 365.24 days (average value)
To know how many days somebody has, use the difference between two dates tool and enter the birth date and today as the reference date for subtraction.
To add days in Excel, add an integer to a date.
Example: 2010/01/01 + 1 = 2010/01/02
To add months, use the function EDATE
Example: EDATE("01/01/2010",1) = 2010/02/01
dCode retains ownership of the "Calculation with Dates" source code. Except explicit open source licence (indicated Creative Commons / free), the "Calculation with Dates" algorithm, the applet or snippet (converter, solver, encryption / decryption, encoding / decoding, ciphering / deciphering, breaker, translator), or the "Calculation with Dates" functions (calculate, convert, solve, decrypt / encrypt, decipher / cipher, decode / encode, translate) written in any informatic language (Python, Java, PHP, C#, Javascript, Matlab, etc.) and all data download, script, or API access for "Calculation with Dates" are not public, same for offline use on PC, mobile, tablet, iPhone or Android app!
Reminder : dCode is free to use.
The copy-paste of the page "Calculation with Dates" or any of its results, is allowed (even for commercial purposes) as long as you credit dCode!
Exporting results as a .csv or .txt file is free by clicking on the export icon
Cite as source (bibliography):
Calculation with Dates on dCode.fr [online website], retrieved on 2024-11-21,