average from (58 rows)or from 29 first day hourly data of every mounth

hi
i have a file with 24 hourly data for one day (Attached) and i want to get average from every 29 first days of every Mounth in a year (2*29=58 row) and becuase of 28 days of February the 31th of January add to it
how can i do it with VBA code could some one help me
thanks so muchaverage.png

Hi
Use these formula and copy down

=IFERROR(AVERAGE(OFFSET($D$1:$O$58,2*29*(ROW(A1)-1),0)),"")

Formula:

Please Login or Register  to view this content.

Regards

hi mr
Thank you for taking the time to solve my thread
yellow column is what i want please correct your formula and if the exception (28 days of
february) makes difficulty WAIVER it.i get average of this mounth separately .
with regard

Use

=IFERROR(AVERAGE(OFFSET($D$1,MATCH(R1,$C$1:$C$1092,0)-1,0,58,12)),"")

Waiver for February is difficult so appreciated if you can handle this "offline".

Hi
Thank you John Topley for your correction.
Follows the formula considering the 28 days of February.
You can also correct to consider the months with 29, 30 and 31 days wearing the same strategy (see column T).

=IFERROR(AVERAGE(OFFSET($D$1,MATCH(R1,$C$1:$C$1092,0)-1,0,58-(DAY(DATE(MOD(R1,100)+1900,MOD(INT(R1/100),100)+1,1)-1)=28)*2,12)),"")

Formula:

Please Login or Register  to view this content.

See the file Book1 (11) (1).xlsx

Fakhteh, I suppose the value that indicates is incorrect. Check, please.
Regards