Formula column result could be incorporated into date column?

[Gopi (Gopikrishna Gnanaprakasam)]

Hi experts,is there any automation to capture the formula column result date into a date column.
I have a project start date.i need to add 5 days from it and show in one date column and from that date add 5 more days to show up in another date column.pls guide me.

[GCavin (Gilles Cavin - Reinventing Formulas in monday.com)]

Hi @Gopi,

You’ll need a 3rd-party app like the Advanced Formula Booster for this.

[jmlytleBMC (Jessica Lytle)]

Unless I’m reading this wrong, you don’t need the formula column. You should be able to use a board automation. Here’s an example of one I use:

When “item is created”,
set “DATE 1” to “today”
and then push “DATE 2” by “7 days”.

Depending on how and when your item is created in the process, you should be able to get where you need to by adjusting the variables. Hope this helps!

[Cplayfair (Christine Playfair)]

Hi, I use a formula column to calculate an end date. You’ll need a start date column. then a formula column with the following formula: ADD_DAYS({Start Date},5) The “5” is the number of days after the start date.