# Calculating Number of days left to end the month

**URL:** https://community.glideapps.com/t/calculating-number-of-days-left-to-end-the-month/61146
**Category:** Ask for Help
**Created:** [April 29, 2023, 1:24am UTC](https://community.glideapps.com/t/calculating-number-of-days-left-to-end-the-month/61146 "2023-04-29T01:24:38Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![Hassan\_Nadeem](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hassan_nadeem/32/72956_2.png) [@Hassan\_Nadeem](https://community.glideapps.com/u/Hassan_Nadeem)
#### Post date: [April 29, 2023, 1:24am UTC](https://community.glideapps.com/t/calculating-number-of-days-left-to-end-the-month/61146/1 "2023-04-29T01:24:38Z")

</div>

How can I get number of days left in the month from a date column? My column A has a date of 27th April 2023 for example. How can I get the number of days left in the month of April? I know there must be an easy formula for that, just can’t get my head around it 😛

---

<div class="post-metadata">

### Author: ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [April 29, 2023, 1:53am UTC](https://community.glideapps.com/t/calculating-number-of-days-left-to-end-the-month/61146/2 "2023-04-29T01:53:26Z")

</div>

If you want to use Glide Math column, I think this works if you replace “month” with your column A:

```auto
day((month - day(month) + 1 + 45) -
day(month - day(month) + 1 + 45)) - day(month)

```

Otherwise, a simple google search reveals the answer:

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/d/7d843654a7a717648a80841fe143052aee006ff5.png)

---

<div class="post-metadata">

### Author: ![Hassan\_Nadeem](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hassan_nadeem/32/72956_2.png) [@Hassan\_Nadeem](https://community.glideapps.com/u/Hassan_Nadeem)
#### Post date: [April 29, 2023, 1:57am UTC](https://community.glideapps.com/t/calculating-number-of-days-left-to-end-the-month/61146/3 "2023-04-29T01:57:46Z")

</div>

> [@Robert\_Petitto](#):
>
> ```auto
> day((month - day(month) + 1 + 45) -
> day(month - day(month) + 1 + 45)) - day(month)
> 
> ```

This worked.

I tried the google one previously it didn’t work for me. Math column didn’t recognize the E0MONTH formula

---

<div class="post-metadata">

### Author: ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [April 29, 2023, 1:58am UTC](https://community.glideapps.com/t/calculating-number-of-days-left-to-end-the-month/61146/4 "2023-04-29T01:58:41Z")

</div>

is not a math column… Excel column

---

<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: [April 30, 2023, 1:59am UTC](https://community.glideapps.com/t/calculating-number-of-days-left-to-end-the-month/61146/5 "2023-04-30T01:59:23Z")

</div>

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