Using day of week in another formula

[normpam]

I know that =text(a2,"Dddd") will give me a day of the week, and can also use the WEEKDAY function. Is it possible to use one of these within another formula?

Example

A2:A7700 has a bunch of dates. i want to calculate how many Sundays, Mondays, etc. there are in the list. I guess I could use a formula in a separate cell to get the days, and then use a COUNT function, but was trying to do it in one formula.

Any ideas?

Thanks!

 

[Joe4]

Try something like this (for Sundays):

=SUMPRODUCT(--(WEEKDAY(A2:A7700)=1))

 

[normpam]

Thanks... got the idea, though I almost never think about using SUMPRODUCT. I've also seen before what the double dash does, though can't remember its name. One problem though. In my real data there are 7,625 records. There could be more in another imported sheet, so I went up to 7,700. But the formula is calculating a total number of results (7,699) even though there are only 7,625 records.

 

[normpam]

Was thinking that maybe an array formula might do the trick, but not sure how to set it up....

 

[Joe4]

But the formula is calculating a total number of results (7,699)

I am confused. It shouldn't return 7699 unless every date in A2:A7700 is a Sunday.

Did you modify the formula? If so, what exactly do you have?

Are the entries in column A really dates, or strings masquerading as dates?
(What does the formula =ISNUMBER(A2) return?)

What appears after the end of the data in column A? Is it just blank cells?