Hi all
When creating automated tasks, if the first task was TODAY the August 17th and I wanted a follow up reminder for 1 month time but the same day - so not TODAY()+30 or 31 as - I am looking for a tweak to this that would create the date to be September 17.
14 Antworten
Eric Praud (Activ8 Solar Energies) Forum Ambassador
If the task is created today, then you can go with 3 formulas, one for each follow up task:
1:
TODAY()+7
2:
ADDMONTHS(TODAY()+7,4)
3:
ADDMONTHS(TODAY()+7,6)