Hi,

I altered you ranges to suit the test data I had set up. This now only
averages Mon - Fri

=AVERAGE(IF((DAY('High Low'!A1:A100)=1)*(WEEKDAY('High
Low'!A1:A100,2)<6)*('High Low'!B1:B100 0),'High Low'!B1:B100))

Array entered

Mike

"notaclue" wrote:

Hi,
Thanks a lot for your help guys!!
got a solution by myself in the meantime

=AVERAGE(IF((DAY('High low'!C6:C245)=17)*('High low'!C6:C245<0),'High
low'!B6:B245))

BUT:
I discovered that I need the workdays otherwise it's pretty useless to me

so the next question how do I exclude the Weekends or better how do i get
the 1st, 2nd, 3rd etc workday of the Month?
"Mike H" wrote:

Hi,

You don't need to filter, put this in a cell.

=AVERAGE(IF(DAY(A1:A100)=ROW(A1),B1:B100,FALSE))

Array entered with
Ctrl+Shift+Enter
then drag down 31 rows for days 1 - 31

Mike

"notaclue" wrote:

Hi,
I#m looking for a Formula that returns me the Value of a specific day of a
month.
Example:
Colum A Dates Colum B Values. Now I need the Average Value for each day of
the month.
Now I want in a new sheet the folowing:
Average Value of 1st of all Month
Average Value of 2nd of all Month
Average Value of 3rd of all Month
etc.
Sure I need the Formula for each of that, My main Problem how to "Filter"
all the 1st, 2nd etc.

Thanks so long