Calculating average high temperatures for each calendar date

Ekrupa25

New Member
Joined
Dec 4, 2020
Messages
1
Office Version
  1. 365
Platform
  1. Windows
I have the daily high temperatures for a city from 1929-2020 (over 33,600 data points), and I am trying to figure out how to calculate the average daily high temperature for each calendar date between April 1 and September 30.

For example, what is the average daily high temperature for April 1 each year? In order to calculate this value, I need to include the daily high temperatures for April 1, 1929; April 1, 1930, April 1, 1931, April 1, 1932, etc. through 2020.

I am trying to figure out how to structure the function to grab the temperatures from dates at specific intervals in the list, but the leap years are frustrating my efforts.

The numerical equivalent for the date April 1, 1929 is equal to 10,684.
For April 1, 1930, you would add 365 to 10,684 to get 11,049.
For April 1, 1931, you would add 365 to 11,049 to get 11,414.
For April 1, 1932, you would add 366 (leap year) to 11,414 to get 11,780

If anyone has any suggestions about how to accomplish this task, I am all ears.
Thank you

Eric
 

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

Forum statistics

Threads
1,223,911
Messages
6,175,334
Members
452,636
Latest member
laura12345

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top