The following formula will return the number of Sundays in the list of
dates in A1:A30.

=SUMPRODUCT(--(WEEKDAY(A1:A30)=1))

Change the 1 to the appropriate day of week (1 = Sunday, 2 = Monday,
...., 7 = Saturday). The display format of the cells doesn't matter.

I have an entire page on my web site about working with days of the
week. See

http://www.cpearson.com/Excel/DayOfWeekFunctions.aspx

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)



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