where col A is properly formatted dates and e1 has the date desired. Weekday
2 is Monday
=SUMPRODUCT((A3:A33E1)*(WEEKDAY(A3:A33)=2))

--
Don Guillett
SalesAid Software

wrote in message
ps.com...
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.