# Thread: Averaging Daily Data (2000)

1. ## Averaging Daily Data (2000)

I have a worksheet with the following: in column A, I have dates beginning with 11/1/1990 in A1, and ending with 10/31/2003. In column B I have daily data corresponding to the day in column A. What I want to do is average all the "November 1st" s in column A in cell C1. I have tried Day(), Month(), and Year() functions, but can't seem to find the correct combination.
Any help?

2. ## Re: Averaging Daily Data (2000)

You can modify the response <post#=227888>post 227888</post#> to the nearly identical question you asked starting <post#=227625>post 227625</post#>:

<hr>Current year average for each date is given by the array formula (ctrl-shift enter to confirm) [all one line]
=avergae(IF((MONTH(Date)=MONTH(\$E2))*(DAY(Date)=DA Y(\$E2))*(YEAR(Date)=YEAR(NOW())),Temperature))<hr>

To just get the month and day
=average(IF((MONTH(A1:A5000)=11)*(DAY(a1:a5000)=1) ,C1:C5000))

Change the range as appropriate.

Steve

3. ## Re: Averaging Daily Data (2000)

Thanks, Steve. I apologize-I ran a search, but evidently overlooked this one. Wow-how do you guys remember all these posts?
Thanks again.
Jeff

4. ## Re: Averaging Daily Data (2000)

I did a search for "steve temperatures" and found the thread

Steve

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•