JavaScript required
We’re sorry, but Coda doesn’t work properly without JavaScript enabled.
Skip to content
Share
Explore
Date Delta
Defining the delta between dates
Why is this relevant?
It happens you need to calculate interests or a NPV and in that context accessing the delta time is important
We explain in our blog how this logic works.
Loading
huizer.medium.com
startDate
endDate
netYears
deltaRestDays
fractionRestDays
leapYear
solution
rawMonths
netMonths
rawDays
netDays
humanFriendly
startDate
endDate
netYears
deltaRestDays
fractionRestDays
leapYear
solution
rawMonths
netMonths
rawDays
netDays
humanFriendly
8/3/2024
9/2/2024
0
30 days
0.08196721311475409
0.08196721311475409
1
0
30 days
30 days
30 days
8/9/2024
10/3/2024
0
55 days
0.15027322404371585
0.15027322404371585
2
1
24 days
24 days
1 month 24 days
8/15/2024
11/4/2024
0
81 days
0.22131147540983606
0.22131147540983606
3
2
20 days
20 days
2 months 20 days
8/1/2024
12/5/2024
0
126 days
0.3442622950819672
0.3442622950819672
4
4
4 days
4 days
4 months 4 days
8/1/2024
1/6/2025
0
158 days
0.4328767123287671
0.4328767123287671
5
5
5 days
5 days
5 months 5 days
8/1/2024
2/7/2025
0
190 days
0.5205479452054794
0.5205479452054794
6
6
6 days
6 days
6 months 6 days
8/1/2024
3/8/2025
0
219 days
0.6
0.6
7
7
7 days
7 days
7 months 7 days
8/1/2024
4/9/2025
0
251 days
0.6876712328767123
0.6876712328767123
8
8
8 days
8 days
8 months 8 days
8/1/2024
5/10/2025
0
282 days
0.7726027397260274
0.7726027397260274
9
9
9 days
9 days
9 months 9 days
8/1/2024
6/11/2025
0
314 days
0.8602739726027397
0.8602739726027397
10
10
10 days
10 days
10 months 10 days
8/1/2024
7/12/2025
0
345 days
0.9452054794520548
0.9452054794520548
11
11
11 days
11 days
11 months 11 days
8/1/2024
8/13/2025
1
12 days
0.03287671232876712
1.0328767123287672
0
12
377 days
12 days
1 year 12 days
8/1/2024
9/14/2025
1
44 days
0.12054794520547946
1.1205479452054794
1
1
378 days
13 days
1 year 1 month 13 days
8/1/2024
10/15/2025
1
75 days
0.2054794520547945
1.2054794520547945
2
2
379 days
14 days
1 year 2 months 14 days
8/1/2024
11/16/2025
1
107 days
0.29315068493150687
1.2931506849315069
3
3
380 days
15 days
1 year 3 months 15 days
8/1/2024
12/17/2025
1
138 days
0.3780821917808219
1.378082191780822
4
4
381 days
16 days
1 year 4 months 16 days
8/1/2024
1/18/2026
1
170 days
0.4657534246575342
1.4657534246575343
5
5
382 days
17 days
1 year 5 months 17 days
8/1/2024
2/19/2026
1
202 days
0.5534246575342465
1.5534246575342465
6
6
383 days
18 days
1 year 6 months 18 days
8/1/2024
3/20/2026
1
231 days
0.6328767123287671
1.632876712328767
7
7
384 days
19 days
1 year 7 months 19 days
8/1/2024
4/21/2026
1
263 days
0.7205479452054795
1.7205479452054795
8
8
385 days
20 days
1 year 8 months 20 days
8/1/2024
5/22/2026
1
294 days
0.8054794520547945
1.8054794520547945
9
9
386 days
21 days
1 year 9 months 21 days
8/1/2024
6/23/2026
1
326 days
0.8931506849315068
1.893150684931507
10
10
387 days
22 days
1 year 10 months 22 days
8/1/2024
7/24/2026
1
357 days
0.9780821917808219
1.978082191780822
11
11
388 days
23 days
1 year 11 months 23 days
8/1/2024
8/25/2026
2
24 days
0.06575342465753424
2.0657534246575344
0
12
754 days
24 days
2 years 24 days
8/1/2024
9/26/2026
2
56 days
0.15342465753424658
2.1534246575342464
1
1
755 days
25 days
2 years 1 month 25 days
8/1/2024
10/27/2026
2
87 days
0.23835616438356164
2.2383561643835614
2
2
756 days
26 days
2 years 2 months 26 days
8/1/2024
11/28/2026
2
119 days
0.32602739726027397
2.326027397260274
3
3
757 days
27 days
2 years 3 months 27 days
8/1/2024
12/29/2026
2
150 days
0.410958904109589
2.410958904109589
4
4
758 days
28 days
2 years 4 months 28 days
8/1/2024
1/30/2027
2
182 days
0.4986301369863014
2.4986301369863013
5
5
759 days
29 days
2 years 5 months 29 days
8/1/2024
2/1/2027
2
184 days
0.5041095890410959
2.504109589041096
6
6
730 days
-
2 years 6 months
8/1/2024
3/2/2027
2
213 days
0.5835616438356165
2.5835616438356164
7
7
731 days
1 day
2 years 7 months 1 day
8/1/2024
4/3/2027
2
245 days
0.6712328767123288
2.671232876712329
8
8
732 days
2 days
2 years 8 months 2 days
8/1/2024
5/4/2027
2
276 days
0.7561643835616438
2.756164383561644
9
9
733 days
3 days
2 years 9 months 3 days
8/1/2024
6/5/2027
2
308 days
0.8438356164383561
2.8438356164383563
10
10
734 days
4 days
2 years 10 months 4 days
8/1/2024
7/6/2027
2
339 days
0.9287671232876712
2.9287671232876713
11
11
735 days
5 days
2 years 11 months 5 days
8/1/2024
8/7/2027
3
6 days
0.01643835616438356
3.0164383561643837
0
12
1101 days
6 days
3 years 6 days
8/1/2024
5/16/2028
3
289 days
0.7896174863387978
3.789617486338798
9
9
1111 days
15 days
3 years 9 months 15 days
No results from filter
Want to print your doc?
This is not the way.
Try clicking the ··· in the right corner or using a keyboard shortcut (
Ctrl
P
) instead.