Thread: day of Month
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
notaclue notaclue is offline
external usenet poster
 
Posts: 4
Default day of Month

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