Date Range Formula

Mary Elise Conzelmann

Hello,

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?

Cristóbal Enrique Santibáñez Pavez

Hi, I tried NETDAYS and it works for me, the dates that you are using in the formula, are they the right format(DATE) ? , about de the second point I don't quite understand what do you want.