I need to apply conditional formatting to a date type cell. I need to write a formula such that, when a the target number for a certain task has been reached, the deadlines for the next target has to be set.
For Example, if the target for task A has reached today, then the start date for the next task should be set two days later.
I tried doing this, however the date column (cell) is not taking in equations.
Can anyone suggest some roundabout ?