I am trying to have a column to show me the next date of a given month and day.

Herculean

For example, I have a column that has contract renewal dates. These would be

Jan 1

Aug 1

September 1

December 1

Etc …

I would like the column next to it to figure out the next date based on todays date. If today is August 28, These values would be:

Jan 1, 2025

Aug 1, 2025

Sept 1, 2024

December 1, 2024

Is this possible? I've tried researching but can't find this specific answer. Thanks in advance!

Matt Lynn-PCG

@Herculean You'll need to create one or more helper columns to convert this.

For the Month you'll have a series of if() statements (12 in total) that say if( Jan, 1, if feb, 2 etc. Then you can use a =date() function to pull the text from the right() side of the string all in all ending up with an actual date column created from the string.