Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need formula to count spinoffs | Excel Worksheet Functions | |||
Subtotals by count | Excel Discussion (Misc queries) | |||
Count consecutive dates only | Excel Discussion (Misc queries) | |||
Finding the date on the 'nth' Monday in this Month in this Year | Excel Worksheet Functions | |||
count no. of dates in a column that falls on certain month & year | Excel Worksheet Functions |