Formula to calculate the average number of days between all dates in a range

Natalia Kataoka

I have tracking sheets that record "sent" and "executed" dates. I am attempting to set up Sheet Summaries to determine the average number of days between all "sent" and "executed" dates in the sheet. (I want to do this without adding an additional column and calculating averages for each row).

It seems I need some type of AVG/COLLECT formula, but this would be new to me and I am having trouble deciphering the syntax.

What I would like it to determine: Find the average number of days between 'sent' and 'executed' for all rows that are 'assigned to' Natalia and 'status' = EXE.

Paul Newcome

There is no way to calculate this without a helper column. If you are concerned with it cluttering up the sheet, you can always hide the column after getting it set up.