JavaScript required
We’re sorry, but Coda doesn’t work properly without JavaScript enabled.
Gallery
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.
Coda the delta between two dates
applied in interest related calculations
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
No results from filter
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
Ctrl
P
) instead.