View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
driller driller is offline
external usenet poster
 
Posts: 740
Default Count Saturdays in a List

it looks you're aware of entering an array formula
lets see another idea maybe something like this
=SUM(--(WEEKDAY(A1:A20)=7))
hit ctrl-shft-ent..

--
*****
birds of the same feather flock together..



"H" wrote:

Hi,

I need to count the number of Saturdays in an array of dates. I used the
following approach, which didn't work. Does anyone have another idea?

{=SUM(IF((WEEKDAY(array1,2)=7),1,0))}

Thanks!