It woudl seem easiest to use a Pivot table here.

Highlight your data, go to Data - Pivot Table

Drop your date and names into Row Fields. Right-click on the list of dates
and seelct Group and Show Detail, then Group...

You should be able to group by weeks here. You can change your start and
end dates. Any data prior to or after these dates will fall into a <start and
end column.

Drop your names into Data Fields as well.

This will give count of each name per week.

"lukesdad" wrote:

i have a database that contails a row of days then one with names

i need to count how many times a name shows up per week

the original database is set up like

date name

3/14/05 tom
3/15/05 frank


so basically how do i group the individual days into week format then count
the times a name show up per week