I need to automate due dates rolling forward

Angela Halsey

I want to automate due dates. For example:

• Column 1: Funding Date (I manually enter)
• Column 2: PPP 8 week end date: Calculated field that is 8 weeks from “funding date”.
• Column 3: Forgiveness Application Due date:  Calculated 90 days from “PPP 8 week end date”

Andrée Starå

Hi Angela,

Try something like this.

=[Funding Date]@row + 8 * 7

=[PPP 8 week end date]@row + 90

Did that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Remember! Did my post(s) help or 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å

Have a look here and let me know if you have any questions.

Andrée Starå

Hi Angela,

Try something like this.

=[Funding Date]@row + 8 * 7

=[PPP 8 week end date]@row + 90

Did that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Remember! Did my post(s) help or 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!

Angela Halsey

Where/how do I enter that formula? Thank you SO much for your help!

Andrée Starå

Happy to help!

Add this one to Column 2

=[Funding Date]@row + 8 * 7

And this one to Column 3

=[PPP 8 week end date]@row + 90

Make sense?

Angela Halsey

How do I add it to the column? I've only used the Conditional Formatting tool.

Andrée Starå

Ok.

You don't actually add it to the column, you add it to the cells in the column.

I'll get back to the post and show you how.

Angela Halsey

That would be awesome! We manage a lot of tax deadlines and the automated date is my #1 priority to help manage all the deliverables. I really appreciate it!

Andrée Starå

Have a look here and let me know if you have any questions.

Angela Halsey

That worked, thank you SO much!!

Andrée Starå

Excellent!

Happy to help!