Days Pending Formula

Could you please help with applying a formula for ‘days pending’?

I have a column named ‘Date of submission’ and in another column I need ‘Pending Days’…so I need to put a formula showing me pending number of days everyday till date of submission.

I also don’t want negative values in the days pending column.

Please try to use this formula:

IF((DATE_DIFF({Date_Column},NOW(),“days”,“integer”)<0),“Complete”,DATE_DIFF({Date_Column},NOW(),“days”))

1 Like

Thanks, really appreciate. It works!