Skip to main content

When a person joins our company I record their actual start date. However, their annual contract renewal date always starts the 1st day of the following month.

I want to be able to record their start date and then have a column showing their next annual renewal date (the first of whatever the following month is) that updates as years go on.

Example) Someone starts on 11/15/2023. I want the renewal column to show 12/1/2024.  Once the present date is past 12/1/2024, I would want that to automatically update to 12/1/2025.

This formula always displays the first day of the month following a certain date.

DATETIME_PARSE( DATETIME_FORMAT( DATEADD({Date}, 1, "month"), "YYYY/MM/1" ), "YYYY/MM/DD" )

 

Terms & ConditionsAccessibility statement