Hi,

I cannot seem to figure this one out...

I have a table that contains e.g.:
Company1 Company2 Company3
Date1 Value11 Value21
Date2 Value12 Value22
Date3 Value13 Value23

etc...

For a function e.g. COVAR i want to select the values that are between
GivenDate1 and GivenDate1-30, for a certain company. The results should be
placed into following table:

Company1 GivenDate1 COVAR
GivenDate2 COVAR
Company2 GivenDate1 COVAR
GivenDate2 COVAR

How on earth should I tackle this? Any help would be really appreciated.

gr. Sergiy