creating median of time period

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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
 
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
 
Back
Top