CODEWITHSUNDEEP
exceldateaverage
user3719559
user3719559

Reputation: 3

Average of dates between many years

I have a problem with calculation in Excel of average date (just need day and month) between dates of many years.

I tried this function:

=AVERAGE(IF(MONTH(D5:D56)=9;DATE(2010;9;DAY(D5:D56))))

Apparently, it just gave me average date of year 2010.

Please for any good advice.

Upvotes: 0

Views: 1150

Answers (1)

PerpetualStudent
PerpetualStudent

Reputation: 832

Does this array formula do what you want?

=AVERAGE(DATE(2010,MONTH(D34:D56),DAY(D34:D56)))

Be sure to enter it using Ctrl-Shift-Enter.

Upvotes: 2

Related Questions