Date - Date submitted to show days passing

[Clair_Arthur]

I have the first column with a start date (Date Submitted). I am wanting to know how to code so that the next column will show how many days are passing since the start date (Date submitted). Then if the status (another column) comes back as closed it’ll then show closed.

[Nathalie_Collin]

Hi @Clair_Arthur :wave: . Welcome to Airtable Community!! :smiling_face_with_three_hearts:

The formula code that I would use is [IF(Status="Closed","Closed",DATETIME_DIFF({Date Submitted},TODAY(),'days')*(-1))]

hth,
Nathalie@VAcePro.com