Formula to place a date in a cell that is greater than a date in another cell by "x" lead time

Mitch@Enmach

Hello again community,

Just wondering if somebody knows how to write a formula that could look at a date in a date ordered column and place a date in another column that is greater by 30 days. From this point, I have an idea to have a formula tick a box based on whether this date is today and then have a conditional formatting rule that colours the row bring attention and show urgency.

Any help or insight would be greatly appreciated :)

Andrée Starå

Hi Mitch,

Try something like this.

=Date@row + 30 

Did that work?

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi Mitch,

Try something like this.

=Date@row + 30 

Did that work?

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Mitch@Enmach

Hi Andrée 

Thanks for coming back to me.

I can't get it to work at the moment. Is this how it should be written?

=DATE([DATE RECEIVED]9) + 30

Sorry if I am missing something simple.

Thanks in advance

Mitch

Andrée Starå

Happy to help!

Try this.

=[DATE RECEIVED]@row + 30

Did it work?

Mitch@Enmach

Hey Andrée,

This is still giving me trouble.

Thanks again.

Andrée Starå

Ok.

It's because you're using the formula in a cell that isn't in a date type column.

Try this.

=[DATE RECEIVED]@row + 30 + ""

Did it work?