Use a Formula to Count Days Since Date (Event)


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?



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.


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