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.
