Date Range Formula


I'm trying to find a formula that will output the average number of days for a date range.

Example: Column 1 has the start date, Column 2 has the completed date

I want to find a formula that will 1) find the total number of days between the start date and end date, 2) average that number of days. I've tried to use NETDAYS and COUNTIFS. Does anyone have a better solution?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!