Date Difference Calculator

Here’s a start:

The problem is always leap years, etc. Either way, you can easily calculate the months left with a modified form of the above.

I haven’t done code in a while but here’s a long way to do it:
MONTH:
$#DM#=1?9:$$#DM#=2?8:$$#DM#=3?7:$$#DM#=4?6:$$#DM#=5?5:$$#DM#=6?4:$$#DM#=7?3:$$#DM#=8?2:$$#DM#=9?1:$$#DM#=10?0:$$#DM#=11?11:$$#DM#=12?10:$ months until Oct.

Then you’d do a formula to count the days between 31 and whatever day you’re on.. to get the number of days difference. IE: Today is the 16th day, so 31-16= number of days.

Calculate the number of days remaining in the month:
((#DIM#-#Dd#)-1) days left

So you’ll get:
10 Months
14 Days
with the above as of Dec 16 2019

You could probably calculate the number of weeks by dividing the number of days left by 7 or something else.. anyways it’s a start. Hopefully someone can chime in further.

1 Like