# Count days with dates

**URL:** <https://community.glideapps.com/t/count-days-with-dates/50776>\
**Category:** Ask for Help\
**Created:** [October 3, 2022, 3:25pm UTC](https://community.glideapps.com/t/count-days-with-dates/50776 "2022-10-03T15:25:07Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Carter](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carter/32/45004_2.png) [@Carter](https://community.glideapps.com/u/Carter)\
**Post date:** [October 3, 2022, 3:25pm UTC](https://community.glideapps.com/t/count-days-with-dates/50776/1 "2022-10-03T15:25:07Z")

</div>

could a math wizard tell me if it is possible to count the number of days remaining with 2 dates?

For example I would like to have the number of days which passed from a date to today.

For example, 12.07.22 to today = 87 days.

On excel it’s quite simple just do =TODAY()-C5, is it possible to have a solution with Glide tables?

Thank you for your help!

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [October 3, 2022, 3:36pm UTC](https://community.glideapps.com/t/count-days-with-dates/50776/2 "2022-10-03T15:36:01Z")

</div>

`Round(Now-Date)`

 ![Screen Shot 2022-10-03 at 11.35.22 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/1/21a579c6dc9ad93374dc4b8e0e775644355fd44a.png)

---

<div class="post-metadata">

**Author:** ![Carter](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carter/32/45004_2.png) [@Carter](https://community.glideapps.com/u/Carter)\
**Post date:** [October 3, 2022, 3:36pm UTC](https://community.glideapps.com/t/count-days-with-dates/50776/3 "2022-10-03T15:36:57Z")

</div>

You’re the best 😍

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [October 3, 2022, 3:41pm UTC](https://community.glideapps.com/t/count-days-with-dates/50776/4 "2022-10-03T15:41:38Z")

</div>

If you think that’s impressive, check out the below thread 😉

> [@Fun with Dates](https://community.glideapps.com/t/fun-with-dates/21684):
>
> I just remembered something from a long time ago. I don’t remember if I had posted about it in this forum or in the old spectrum forum. Can’t find the post in either forum right now. Working on these posts re-triggered this memory. What I had discovered back then is how ridiculously forgiving the calendar layout is. It can take dates in a variety of formats and still determine the correct date to show. But the really cool thing I had discovered is that you can feed it certain types of te…

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [October 4, 2022, 3:42pm UTC](https://community.glideapps.com/t/count-days-with-dates/50776/5 "2022-10-04T15:42:15Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.