Use a Formula to Count Days Since Date (Event)


#1

I have three columns:

  1. Email
  2. Sent (Yes/No)
  3. Date (Sent)

I would like to add a fourth col to display the number of days since the email was sent (i.e. Current Date - Date Sent, displayed as Days). How can I write a formula for that?


#2

Use DATETIME_DIFF():

Also, I think you could remove the Sent field, cause you already have that information in Date field: if it is filled, it is send.


#3

Thank you, managed to get it working. Yes, I agree. Thank you!