See help on WEEKDAY Function.

Use a helper column to derive the day number from your dates.

=WEEKDAY(A1) copied down.

Count on that column.

=COUNTIF(A1:A100,1) returns a count of Sundays


Gord Dibben MS Excel MVP


On Mon, 17 Aug 2009 11:53:01 -0700, 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