Days Pending Formula

Ask the Community Formulas
#1

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.

days-pending
days-pending1349×607 61.8 KB

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

#2

Please try to use this formula:

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

1 Like
#3

Thanks, really appreciate. It works!