troubleshooting Question

Splitting date range into weekly buckets

Avatar of Gerald Connolly
Gerald ConnollyFlag for Australia asked on
Microsoft OfficeMicrosoft Excel
7 Comments2 Solutions627 ViewsLast Modified:
i have the following data

      Daily Avg
22/10/2009      26.34029356
27/01/2010      94.54060731
23/04/2010      83.35397306
21/07/2010      19.88248141
16/08/2010      14.78855542
17/08/2010      0
25/10/2010      24.35493734
28/01/2011      101.1063237
20/04/2011      66.19501607

i.e. 4-Sep-2009 to 22-Nov-2009 the daily average was 26.34...

what i need is to split this into 52 weekly buckets per year, is this something i can do with Excel functions or does it need VBA programming
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 2 Answers and 7 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros