If you mean the range, i.e. the earliest date to the latest date, Frank's
formula will do that, but you need to add 1 if the range is inclusive on both
ends, i.e. =MAX(A1:A4200)-MIN(A1:A4200)+1
Note that calculation includes weekend days. I'm assuming if this is a
business which doesn't operate 7 days per week, you would want to exclude
weekends. A formula to do that might be
=NETWORKDAY(MIN(A1:A4200),MAX(A1:A4200)
which will give you the number of weekdays.
And what about weekdays where there were no transactions. Is that possible? If
so, do you want to include them (sales = 0) for that day? Or should they be
excluded?
I wonder if a Pivot Table might be a better solution. If you put the dates in
a column field, and count of dates in the data field, you could then put a
formula below the tables that averages the data field. This approach would not
include dates with no sales unless you specifically added those dates to the
list.
