# Formula to calculate no. of days after training completion

Topic Labels: Formulas
Solved
467 2
cancel
Showing results for
Did you mean:
5 - Automation Enthusiast

Hello,

Quick question. I have a field that calculates no. of days before start of a workshop. This is the formula I'm using-

DATETIME_DIFF({Start Date/Time}, NOW(),'days').

I now want to create a field that calculates number of days 'after' a workshop. I want to use this for an automation. So for eg: if days after training completion =7, send email. What formula can I use here? I tried using a dateadd formula but I'm getting it wrong.

Thank you 🙂
1 Solution

Accepted Solutions
11 - Venus

This formula will output 1 after 7 days of the date.
How about triggering an automation that sends an email when it reaches 1?

``IF(DATETIME_DIFF(DATEADD({Date},7,'Days'), TODAY(),'days')=0,1)``

Now() includes time, so there may be time differences. Today() is date only.

2 Replies 2
11 - Venus

This formula will output 1 after 7 days of the date.
How about triggering an automation that sends an email when it reaches 1?

``IF(DATETIME_DIFF(DATEADD({Date},7,'Days'), TODAY(),'days')=0,1)``

Now() includes time, so there may be time differences. Today() is date only.

5 - Automation Enthusiast

Thank you so much!