You could use:

=SUMPRODUCT(--(TEXT(A1:A1000,"dddd")="Monday"))

to count how many Mondays there are in cells A1:A1000. The criteria
can be a cell reference (ie a cell containing Monday, or Tuesday,
etc...). Adjust your range to suit.

Hope this helps!

Richard



wrote:

I'm curently working on the spreadsheet to count how many reservations
made by Monday, Tuesday, Wednsday, etc. Yes, I work at hospitablity
business, we want to know the production(reservation) made by each day
so we can better arrange the staffs.

Since, we are looking at resevation date not the check in date, so
those reservations weren't necessarily made in the same month. some of
them can be back to 6 months ago. I don't know which function in excel
could generate data from the format of " Sunday, Febuary 21, 2006" and
sum the day by "Monday, tuesday, .." I hope my question is clear.
Thank you for your help.