Date Default to 30 Days

Brittany Marie

Hi!

I am trying to put together a formula that says: " If the Renewal Alert Date is blank, change column to 30 days"

Andrée Starå

Hi @Brittany Marie

I hope you're well and safe!

Do you mean it should change to the text "30 days" or add 30 days to a date?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Brittany Marie

@Andrée Starå

Thanks for getting back to me, so I want to create 30 days to date

Right now I have a date in the Renewal End Date column that will populate a date that is 45 days before the contract end date.

=[Contract End Date]@row - 45

So, I need help adding to this formula that says if the Contract End Date column is blank change the date to 30 days out from the Contract Start Date . But, had some issues whether I should use Ifs or if blank function