LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need formula to count spinoffs jamescarvin Excel Worksheet Functions 1 July 14th 06 04:07 PM
Subtotals by count PineRest Excel Discussion (Misc queries) 1 May 10th 06 05:09 PM
Count consecutive dates only [email protected] Excel Discussion (Misc queries) 0 May 4th 06 03:58 PM
Finding the date on the 'nth' Monday in this Month in this Year agarwaldvk Excel Worksheet Functions 1 April 17th 06 10:53 PM
count no. of dates in a column that falls on certain month & year RawSugar Excel Worksheet Functions 2 October 20th 05 10:50 PM


All times are GMT +1. The time now is 10:40 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"