# Find the last day of the following month

**URL:** <https://community.glideapps.com/t/find-the-last-day-of-the-following-month/21557>\
**Category:** Ask for Help\
**Tags:** holdmybeer\
**Created:** [January 22, 2021, 6:02am UTC](https://community.glideapps.com/t/find-the-last-day-of-the-following-month/21557 "2021-01-22T06:02:57Z")\
**Posts on this page:** 8\
**Page:** 3

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [January 17, 2023, 4:11am UTC](https://community.glideapps.com/t/find-the-last-day-of-the-following-month/21557/41 "2023-01-17T04:11:11Z")

</div>

I just threw this together quickly based on how I currently understand your goal.

So basically it’s 3 columns. An initial start date, which will only be set once and never change, and then a calculated current Start Date and a calculated current End Date.  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/d/6d47221c27c4befb154921f97f133a6423a4f4b7.png)

- Initial Start Date is just a date column. Nothing special about it.
- mth-Start Date is calculated based on the current date.  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/b/fb5854b83e16d45eac2b8c70ad31f84c1dc28a37.png)
- mth-End Date just adds 30 days to that calculated start date.  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/6/d6958b67f82121916ba57cfff9f275cb33236ae5.png)

Let me know if I’m misunderstanding anything.

---

<div class="post-metadata">

**Author:** ![Joe\_Gabriele](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/joe_gabriele/32/57595_2.png) [@Joe\_Gabriele](https://community.glideapps.com/u/Joe_Gabriele)\
**Post date:** [January 17, 2023, 4:17am UTC](https://community.glideapps.com/t/find-the-last-day-of-the-following-month/21557/42 "2023-01-17T04:17:19Z")

</div>

Awesome!  
And so using your example, when the mth-EndDate is reached, will the mth-Start Date change, causing the mth-End Date to also change.

Using your first row of Initial Start Date of 1/1/23, the mth-End Date is 1/31/23. Once it becomes say 2/1/23, will the mth-Start Date change to become 2/1/23, causing the mth-End Date to then change to 3/2/23?

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [January 17, 2023, 4:22am UTC](https://community.glideapps.com/t/find-the-last-day-of-the-following-month/21557/43 "2023-01-17T04:22:24Z")

</div>

Obviously haven’t done extensive testing on this, but that appears to be the case.

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/5/4554f714cd73b6466a9587c1e42704e61c1461b8.png)

---

<div class="post-metadata">

**Author:** ![Joe\_Gabriele](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/joe_gabriele/32/57595_2.png) [@Joe\_Gabriele](https://community.glideapps.com/u/Joe_Gabriele)\
**Post date:** [January 17, 2023, 4:25am UTC](https://community.glideapps.com/t/find-the-last-day-of-the-following-month/21557/44 "2023-01-17T04:25:27Z")

</div>

Perfect! What took you a few minutes would have taken me forever. Thank you so much!

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [January 17, 2023, 4:29am UTC](https://community.glideapps.com/t/find-the-last-day-of-the-following-month/21557/45 "2023-01-17T04:29:41Z")

</div>

Double check my math. 30 days from Dec 17th is Jan 16th, which also becomes the start of a new cycle. I think the start date is a day early, but I want to make sure you agree.

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [January 17, 2023, 4:35am UTC](https://community.glideapps.com/t/find-the-last-day-of-the-following-month/21557/46 "2023-01-17T04:35:19Z")

</div>

If it is in fact a day early, then I think it’s just a small tweak to the formula. Be sure to throw some dates at it and test it to make sure you get the expected results.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/5/658a0ce2056ccdd634ae6ceeb1b0e07b18818d87.png)

---

<div class="post-metadata">

**Author:** ![Joe\_Gabriele](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/joe_gabriele/32/57595_2.png) [@Joe\_Gabriele](https://community.glideapps.com/u/Joe_Gabriele)\
**Post date:** [January 17, 2023, 4:39am UTC](https://community.glideapps.com/t/find-the-last-day-of-the-following-month/21557/47 "2023-01-17T04:39:54Z")

</div>

Thanks, I’ll test it out and tweak as needed!

---

<div class="post-metadata">

**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\
**Post date:** [January 17, 2024, 4:49pm UTC](https://community.glideapps.com/t/find-the-last-day-of-the-following-month/21557/48 "2024-01-17T16:49:10Z")

</div>

Closed on January 17, 2024, 4:49pm UTC



[Previous page](https://community.glideapps.com/t/find-the-last-day-of-the-following-month/21557.md?page=2)
