# Calculating remaining days of month

**URL:** <https://community.glideapps.com/t/calculating-remaining-days-of-month/70240>\
**Category:** Ask for Help\
**Tags:** date-math\
**Created:** [January 30, 2024, 10:41am UTC](https://community.glideapps.com/t/calculating-remaining-days-of-month/70240 "2024-01-30T10:41:54Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![samwagner](https://avatars.discourse-cdn.com/v4/letter/s/f14d63/32.png) [@samwagner](https://community.glideapps.com/u/samwagner)\
**Post date:** [January 30, 2024, 10:41am UTC](https://community.glideapps.com/t/calculating-remaining-days-of-month/70240/1 "2024-01-30T10:41:54Z")

</div>

Is there a way to calculate the exact number of renaining days in the current month?

Examples:

Today is 01/30/2024. So the number of full remaining days in January is 1.

If today was 02/02/2024, the number would be 27 (leap year!)

So what formula will give back the exact number for every given date (NOW)?

Thanks in advance.

---

<div class="post-metadata">

**Author:** ![Antonino\_Nolasco](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/antonino_nolasco/32/80601_2.png) [@Antonino\_Nolasco](https://community.glideapps.com/u/Antonino_Nolasco)\
**Post date:** [January 30, 2024, 10:59am UTC](https://community.glideapps.com/t/calculating-remaining-days-of-month/70240/2 "2024-01-30T10:59:00Z")

</div>

Hi @samwagner  
Change “Date” with your Date column:

```auto
Day(Date-Day(Date)+45
-
Day(Date-Day(Date)+45))-Day(Date)

```

---

<div class="post-metadata">

**Author:** ![samwagner](https://avatars.discourse-cdn.com/v4/letter/s/f14d63/32.png) [@samwagner](https://community.glideapps.com/u/samwagner)\
**Post date:** [January 30, 2024, 2:23pm UTC](https://community.glideapps.com/t/calculating-remaining-days-of-month/70240/3 "2024-01-30T14:23:40Z")

</div>

So awesome!

Thanks a bunch, @Antonino_Nolasco

---

<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:** [February 6, 2024, 2:24pm UTC](https://community.glideapps.com/t/calculating-remaining-days-of-month/70240/4 "2024-02-06T14:24:32Z")

</div>

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