Automatically update the month every month while keeping the day unchanged

Ask for Help
1

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?

2 
Now - Day(Now) + 15

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

2 Likes
3

Thank youuu!!!

4

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