Calculate Number of Days Remaining from Due Date in Notion

Formula for number of days remaining:
*Check pinned comment for updated formula.*
**Be sure the name of your Date Property (in my case, "Due Date") matches the name in your formula if you're having issues with the formula.
-------- ABOUT:
Covering all things productivity and growth that I love.
Focused on keeping videos short and sweet.
Subscribe and stay tuned for new weekly videos!:)

[@jameshjay22]

Try this formula instead! (It will add: # days remaining & # of days overdue) *Updated formula: if(empty(prop("Due Date")), "", (format(abs(dateBetween(prop("Due Date"), now(), "days")) + 1) + format(if(((dateBetween(prop("Due Date"), now(), "days") + 1) 0), " days remaining", ""))))))

[@anders_dahlberg]

Great formula! Works perfect... however, a suggestion for improvement. It would be nice if it could handle when on one day is remaining and instead write "1 day remaining" . As it is now I get "1days remaining". Anyway thanks for the great formula!

[@bredket3334]

it doesn't work

[@faithlikecoffeee]

work great! Thank you

[@ritinjain]

Doesn't work correctly for the month of Feb somehow

[@lanlalynn7156]

it's work ! (april, 2023)

[@EshanAnas]

You literally saved me from building an app to do this one simple thing. The excel sheets and other stuff are all nonsense to me. THANK YOUUUUUUUUUUUU

[@user-ce9nu3wq9p]

Thank you James, you saved me a lot of time.

[@shmkrar1153]

Super short & Helpful!!!

[@jasminahristova]

Works perfectly! Thanks :)🙏

[@reemxahmed]

Thank you so much! This was very helpful.

[@explorer326mpd]

thank you for making this simple to understand and follow.!!

[@jameshjay22]

Thanks Justin! And you’re welcome!:)

[@HannahDeloy]

This is awesome! Thank you!

[@mikajuuzuo3356]

Thank you so much!

[@IlkhomjonYuldoshev]

Thanks Man, you helped a lot

[@erinc7261]

Thank you so much!!

[@thechristhetics]

You're very helpful sir. Thank you.

[@leituraseoutrasaventuras]

THANK YOU!

[@gyuuv]

hi thank you so much for this! is there a way to make it say "due today" on the date due instead of "1 day remaining"?

[@LuisKarlosML]

Thanks 🙌🏼

[@juribrand3656]

thank you really much

[@dvsbreitmann4914]

Thanks!

[@ThisIsOmar143]

Wow! thanks this was helpful

[@KapsLockisLive]

Thank You buddy

[@akashghosh4260]

Thanksss, that was very helpful.

[@jameshjay22]

Thanks Akash! Glad it helped:)

[@thenerdlad1101]

thanks man

[@Aya-oj4kh]

super helpful, thank you so much! may i suggest for a how-to vid for creating a database template from an existing page in the same database?

[@jameshjay22]

Oh that's a great idea! I currently use a single master database for all my pages, so I haven't come across this yet. I'll definitely take a look at it:)

[@md.nurealamhussain5295]

thanks

[@juliocesardecarvalhorodrig3903]

god bless u

[@it.s_Raine]

I've been trying to create a countdown timer in notion and been struggling with this. I have 3 Properties created in a table namely: Duration(# property), Start Date(date property) and a formula property that tells the date when the duration ends. What I want, is to create a property that tells how many days remaining until the due date with respect to the "Start Date. I also want to know how to make the timer/counter stop when 100% progress is reach. Hope you can help me with this.

[@MCandMosRandomChannel]

have you managed to do this yet? pls. Thanks

[@it.s_Raine]

@@MCandMosRandomChannel I created 4 properties: Duration(# property), Start Date(date property), End Date(formula property), and Days Left(formula Property). The formula for End Date is: dateAdd(prop("Start Date"), prop("Duration"), "days") For Days Left: "📅" + if(ceil(dateBetween(prop("End Date"), now(), "hours") / 24) == 0, " Today", if(prop("End Date") < now(), format(abs(ceil(dateBetween(prop("End Date"), now(), "hours") / 24))) + " Days Overdue", if(prop("End Date") > now(), format(abs(ceil(dateBetween(prop("End Date"), now(), "hours") / 24))) + " Days Remaining", ""))) I just input how many days is the duration for certain project and when it will start then the rest will automatically tell you the date it ends and the countdown will start.

[@MCandMosRandomChannel]

Hey bro, I was tryting to introduce a age function where it shows DAYS OLD on the page. ... Is this possible to do please? Thanks

[@la_cobus]

The formula used in the video doesn't work anymore. The one shown in the pinned comment does work, but I don't know how it works...and I watched the video looking for explanation - would love if you updated the vid!

[@lucasantor345]

Hi How can i do to Automatically put DONE when the task is attempted?

[@satyatadhargawe535]

Hey, can you tell me how to calculate the number of days from a start date to today's date, please? And thank you for the useful content.

[@jameshjay22]

Sure! Is the formula not working on your end?

[@nicolasbarrios7403]

@@jameshjay22 she means how calculate formula for example: start date: april 12 and due date: april 20. So the remaining days are 8. So, how we could calculate it?

[@ThanhNguyen-hn3xz]

empty(prop("Due Date")) ? "" : concat(format(abs(dateBetween(prop("Due Date"), now(), "days")) + 1), format((dateBetween(prop("Due Date"), now(), "days") + 1 0) ? " days remaining" : ""))) He had pinned it

[@ThanhNguyen-hn3xz]

And if you do not want to have the word "days remaining", use this: empty(prop("Due Date")) ? "" : concat(format(abs(dateBetween(prop("Due Date"), now(), "days")) + 1))

[@JocyBurtonof]

how about days since? like 5 days since last reviewed.

[@kokoo1322]

Hi, is there a tweak in the code if I ever want to turn on "end date" on my date property?

[@SuperCavalry]

dateEnd(prop("Do Date"))

[@FeruMohammed]

Hey, I want to make a formula to "count the days" since created. Can you help? It's for tracking my job applications. A company has cooling period of about 90 days or 1 year. By this way, I can re-apply to the company after completing the cooling period.

[@hamnaarshad]

This formula is working for me, try it & see if it works for you: dateBetween(now(), prop("Date Created"), "days")

[@FeruMohammed]

@@hamnaarshad Yes. Found it. Tq.

[@alejandramendezmiguez4607]

love u

[@hieuluc8888]

Try this if you want result like: 9 Days 1 Hours 56 Minutes lets(totalMinutes, dateBetween(prop("Due"), now(), "minutes"), days, floor(totalMinutes / 1440), hours, floor((totalMinutes % 1440) / 60), minutes, totalMinutes % 60, format(days) + " Days " + format(hours) + " Hours " + format(minutes) + " Minutes")

[@frayudaadriansyah4253]

thank you. can you edit formula? when time overdue its show in days remaining show a overdue. if one days ago time is not show a day

[@hieuluc8888]

@@frayudaadriansyah4253 Basically, you just need to add two if lines as follows: lets(totalMinutes, dateBetween(prop("Due"), now(), "minutes"), days, floor(totalMinutes / 1440), hours, floor((totalMinutes % 1440) / 60), minutes, totalMinutes % 60, if(totalMinutes < 0, "Overdue", if(days==0, format(hours)+"h:" + format(minutes) + "m", format(days) + "d:" + format(hours) + "h:" + format(minutes) + "m")))

[@mariyajim1872]

It not working - it just says 0 DAYS 0 HOURS 0 MINUTES

[@frayudaadriansyah4253]

@@mariyajim1872 change due date with due

[@frayudaadriansyah4253]

@@hieuluc8888 thank you somuch. do you have template for free?

[@nordiin88]

Hi, how do you show the days between 2 Date properties in a full day and the remaining hours? Something like this Date A: July 24 2022 ,10 Pm Date B: July 29 2022, 7:25 AM Result: 4Days 9hr 25min

[@mohaimenulislam7817]

hi, you got solution for this

[@hieuluc8888]

@@mohaimenulislam7817 lets(totalMinutes, dateBetween(prop("Due"), now(), "minutes"), days, floor(totalMinutes / 1440), hours, floor((totalMinutes % 1440) / 60), minutes, totalMinutes % 60, format(days) + " Days " + format(hours) + " Hours " + format(minutes) + " Minutes")

[@hieuluc8888]

lets(totalMinutes, dateBetween(prop("Due"), now(), "minutes"), days, floor(totalMinutes / 1440), hours, floor((totalMinutes % 1440) / 60), minutes, totalMinutes % 60, format(days) + " Days " + format(hours) + " Hours " + format(minutes) + " Minutes")

[@SuperCavalry]

​@@hieuluc8888 this formula is so far the best as it shows the countdown in a very granular fashion, but how can we make it stop once the status properties are "done" ?

[@lucasantor345]

@@SuperCavalry you found solution?

[@brookerule9168]

i get an error saying "Argument of type text does not satisfy function concat. [23,69] Argument of type text does not satisfy function concat. [71,206]" what have I done wrong?

[@thechristhetics]

if(empty(prop("Due Date")), "", (format(abs(dateBetween(prop("Due Date"), now(), "days")) + 1) + format(if(((dateBetween(prop("Due Date"), now(), "days") + 1) 0), " days remaining", ""))))))

[@thechristhetics]

Just add if at the beginning

[@ambercolin3332]

i cant click on done it wont accept teh code i have tried other codes and its the same problem what do i do?

[@marianasanchez3210]

Same 😭

[@odarshan..]

How to make after the number show the word days like this: "30 days"

[@samiraordahi]

Did you get it?

[@odarshan..]

@@samiraordahi no.

[@santicarvalho]

i lov u

[@seanace9471]

The formula isn't working on mine

[@jameshjay22]

Be sure the name of your Date Property (in my case, "Due Date") matches the name in your formula if you're having issues. Otherwise, it should be working:)

[@seanace9471]

@@jameshjay22 thanks

[@tiffany4970]

@@jameshjay22 it's still isn't working for mine

[@elainewinters4807]

mine isnt working

[@jameshjay22]

Did you try using the pinned formula? empty(prop("Due Date")) ? "" : concat(format(abs(dateBetween(prop("Due Date"), now(), "days")) + 1), format((dateBetween(prop("Due Date"), now(), "days") + 1 0) ? " days remaining" : "")))

[@elainewinters4807]

@@jameshjay22 thanks so much 🙏 yeah sorry I didn't see

[@elainewinters4807]

Also do u know how to make it so it shows the due date on the board when u change it from table to board

[@jameshjay22]

@@elainewinters4807 No problem!:) Unfortunately, I don't; I mainly use the table view only.

[@labulabuland]

✅w