# Automatically update the month every month while keeping the day unchanged

**URL:** <https://community.glideapps.com/t/automatically-update-the-month-every-month-while-keeping-the-day-unchanged/69195>\
**Category:** Ask for Help\
**Created:** [January 3, 2024, 9:55am UTC](https://community.glideapps.com/t/automatically-update-the-month-every-month-while-keeping-the-day-unchanged/69195 "2024-01-03T09:55:58Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Stefania\_Oancea](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/stefania_oancea/32/60457_2.png) [@Stefania\_Oancea](https://community.glideapps.com/u/Stefania_Oancea)\
**Post date:** [January 3, 2024, 9:55am UTC](https://community.glideapps.com/t/automatically-update-the-month-every-month-while-keeping-the-day-unchanged/69195/1 "2024-01-03T09:55:58Z")

</div>

Hello!  
Can anyone help me in this problem?  
I want to create a formula in Glide to automatically update the month every month while keeping the day unchanged, for example, to transform 15.05.2024 into 15.06.2024. I have a payment deadline for a contract on the 15th of each month, and it would be helpful if it automatically updated the month to use that data in another formula.  
Is this possible?

---

<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:** [January 3, 2024, 9:59am UTC](https://community.glideapps.com/t/automatically-update-the-month-every-month-while-keeping-the-day-unchanged/69195/2 "2024-01-03T09:59:24Z")

</div>

```auto
Now - Day(Now) + 15

```

The above will always give you the 15th of the month for the _current_ month.

---

<div class="post-metadata">

**Author:** ![Stefania\_Oancea](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/stefania_oancea/32/60457_2.png) [@Stefania\_Oancea](https://community.glideapps.com/u/Stefania_Oancea)\
**Post date:** [January 3, 2024, 10:01am UTC](https://community.glideapps.com/t/automatically-update-the-month-every-month-while-keeping-the-day-unchanged/69195/3 "2024-01-03T10:01:30Z")

</div>

Thank youuu!!!

---

<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:** [January 10, 2024, 10:02am UTC](https://community.glideapps.com/t/automatically-update-the-month-every-month-while-keeping-the-day-unchanged/69195/4 "2024-01-10T10:02:18Z")

</div>

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