match data by day

M

mcarrigg

Hi Guys,

I have some excel sheets and have a question regarding grouping the data by
day. I want to compare sales figures for each day of current month compared
to last financial year corresponding month. The catch is that I dont want to
compare each date (ie compare 1st December of 2006 with 1st Dec 2007), I want
to compare data from the particular day (ie I want to compare sales figures
from the first monday of december 2006 to the first monday in December 2007.

I currently have a February Workbook. It has three worksheets (1,
Comparison Sheet, 2. Feb 2007 data, 3. Feb 2008 data)

The two data worksheets have a format of..

Date Day Ttl Sales Confec Hot Food Magazines , etc


So I want the comparison sheet to take the values from the 2007 data and
then search through the 2008 data match the values by day (eg say the 5th feb
2007 is a monday and the 1st feb 2008 is a monday - I dont want to compare
both first of feb figures, I want to compare the two monday figures.

I was hoping to get something that looks like this...

Date Day Ttl Sales Confec Hot Food Magazines , etc

5feb07 Mon 4,500 800 2900 800 ...
1feb08 Mon 5,200 770 3430 1000 ...

5feb07 Tue 4,600 750 3150 700 ...
2feb08 Tue 4,200 800 2800 600 ...


Hopefully I have explained myself ok.

The problem I am having is grouping the days automatically. At the moment I
am having to put the cell reference in manually for each day.

Your help is greatly appreciated!
 
R

Roger Govier

Hi
01 Feb 08 is a Friday, not a Monday.

That aside, if you take the latest date and subtract 364, you will get the
equivalent day 1 year earlier

04 Feb 08 - 364 = 05 Feb 07
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top