Vendor Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7
Jun 8 Jun 15 Jun 22 Jun 29 Jul 6
Jul 13 Jul 20
Manhattan 346 349 351 348 340
333 328
El Paso 518 549 558 584 596
607 616
Terra H 478 484 470 485 470
506 491

Above is a sampling of my data. I am in desparate need of a calc that will
give me the average for each Vendor by Month according to the month that is
associated to Week. (there are actually 16 weeks). Every week my dates will
change. Thank you!