Average number of day formula

FGCC Smartsheet

I have these two columns "Date Created" and "Date Closed". I need to write a formula that looks at all 1000+ rows of data and produces an average amount of days it takes to close a row of data. The formula will be in my calculations sheet. So, I'll be referencing this data. Should I use the "averageifs"? I really appreciate the assistance with this formula.

Paul Newcome

You will need a separate column that calculates the number of days on each row and then average this new column.

FGCC Smartsheet

That makes perfect sense. I will work on this and let you know.

Thanks!