Using the WEEKDAY function which gives Sunday = 1, Monday = 2, etc.

=SUMPRODUCT(--(WEEKDAY(A1:A10)=2))

This gives a count of how many cells in A1:A10 are Thursday. Note that
SUMPRODUCT can't callout entire column (A:A) unless using XL 2007. Feel free
to change the 2 to a cell reference, if desired.

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Greg" wrote:

Good day,

I am working on a project to model some work flows. I have a date column
that is entered as 8/15/2009, and formatted to show "Friday, August 15,
2009". Now, I want to count the number of rows for Monday, Tuesday,
Wednesday, etc.

However, since the underlying data is all in the 8/15/2009 format, I can't
seem to either sort or run calcuations on the data for what I need.

Any help is greatly appreciated!

Thank you in advance,
Greg