View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Doug Doug is offline
external usenet poster
 
Posts: 460
Default Patient Demand on X Day of the Month

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