Need Super Simple Formula (7 days before "Due Date")

tylermh

I want a new column to reflect the date 7 days before an existing due date column.  What's the formula?

Andrée Starå

Hi Tyler,

Try this.

=[Due Date]@row - 7

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

I hope this helps you!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

tylermh

That worked!  Thanks!

Andrée Starå

Great!

Happy to help!