View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] happybird66@gmail.com is offline
external usenet poster
 
Posts: 3
Default How to count by monday, tuesday, ...in a year?

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.