Display a weekly summary

M

markag

Hi all,

I have a full years worth of data, a value for every day of the year, and I
need to have a worsheet that summarizes the previous weeks data. I would like
to show the value for each day of the week, monday through sunday. I'm
somewhat new at excel and I don't have a lot of experience with date & time
functions. If someone could help me out I would really appreciate it.

Thank you,
 
M

markag

My data is arranged like this

Date Daily Values
1/1/2006 75%
1/2/2006 82%
1/3/2006 57%
. .
. .
. .
12/31/2006 78%

I just want to pull the data for the previous week into a separate worksheet
in the same file. I don't need someone to do it for me; I would like to
learn how so I can do it again later if needed. Would I have to use some
sort of VLOOKUP and TODAY functions?
 
Top