You are going to run into problems with that. This year April has 5 Fridays.
Last year it only had 4 Fridays. How would you like to deal with that type of
situation? You may be better off matching 52 weeks this year over a
comperable 52 weeks last year. At that point things get a lot easier to work
with.
--
HTH...

Jim Thomlinson


"DOUG" wrote:

I need to summarize and compare patient demand for appointments going back
over three years. I can pull the data and display the days of the week. In
Ms Excel, is there a way to line up the same days of each month - but not the
dates?

For instance, I need to line up and average all of the first Mondays in May,
all of the first Tuesdays in May and so on.

DOUG in Wichita