creating median of time period

L

LB

I am working with water quality data organized by sample date, with samples
taken 2x/month. I need to sum the sampled parameter values for a time period
of interest, with the sample date being the median of that time period. How
do I create the time periods of interest when the samples are not recorded on
the same dates each month?
THanks
 
C

CLR

Please supply a short list of sample dates, and whatever "time periods of
interest" you would like to see..........then perhaps someone can give you a
formula to automate the process.

Vaya con Dios,
Chuck, CABGx3
 
L

LB

10/13/2006
10/20/2006
11/11/2006
11/20/2006
12/7/2006
12/15/2006
1/12/2007

I need to capture time periods around the sample date, where the sample date
is the median. Make sense?
Thanks again
 
C

CLR

Not completely.............please give examples of the "Time periods" you
expect to see as a result of the shown dates..........

Vaya con Dios,
Chuck, CABGx3
 
Top