Issues with Auto-Update Dates

I have a project schedule with start and end dates listed for each phase of the project. (Phase 1: Start Date - 2/1/2023, End Date - 3/1/2023). I am experiencing issues with the year automatically updating in the date columns when a new year begins. I want the year in the date columns to automatically update to the current year while keeping the day and the month the same. (Phase 1: Start Date - 2/1/2024, End Date - 3/1/2024). Is there a way this can be accomplished?

Thank you for your help!


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!