Ute4Life
New Member
- Joined
- Mar 16, 2009
- Messages
- 21
I have data arrayed in a spreadsheet, with individual orders in rows, and order dates (daily) and revenue in columns. I need to associate the daily orders and revenue with the calendar weeks (by number), where Week 1 is Jan4 - Jan10, Week 2 is Jan11 - Jan16, and so on. I would like to see, by Week #, how many and how much revenue is associated with the orders. Is there a function in Excel to accomplish this?