Excel - weekly date summary to month

[blackduck]

I have a column with week ending dates (actually formula ie =A2+7 etc) and a corresponding column with sales amounts.
On a separate worksheet I want a monthly summary of sales. I dont want to manually highlight each range of weeks for each month because this will change when the year date changes.
Is there a way to do this?

thanks
K

 

[SkipVought]

Hi,

Check out the PivotTable Wizard.

If you know what you are doing, something like what you described can be done in a few seconds.

Skip,

_{[red]Be Advised![/red] A chicken, who would drag a wagon across the road for 2 cents, is…
POULTRY in motion to PULLET for a PALTRY amount!}

 

[blackduck]

Thanks Skip, when it comes to pivot tables I finally get it! and they are great.

I also found the month function eg.
=MONTH(A3)
will return 1 where (A3) is 15/01/2006

So its easy to include this column to summarise the pivot table into months 1, 2, etc

thanks again
K

 

[SkipVought]

I'd be very careful just using the Month function. What happens to YEAR?

Rather take a look at Grouping your Date field in the PT by Month & Year -- right click on the date field button and select Group and Outline...

Skip,

_{[red]Be Advised![/red] A chicken, who would drag a wagon across the road for 2 cents, is…
POULTRY in motion to PULLET for a PALTRY amount!}