So circling back to your original post, you have a start date for everybody, and now you just need to calculate the dates where next steps start?
Adapting this formula from @Jeff_Hager .
((Now-DAY(Now)+15)+(Years*365.25))
-
DAY((Now-DAY(Now)+15)+(Years*365.25))
+
DAY(Now)
With Now being the Start Date, Years being:
1 for Step 2
2 for Step 3
2.5 for Step 4
3 for Step 5
2 Likes
