Omkar,

FWIW, I've since responded to your follow on queries in your earlier post,
http://tinyurl.com/qkm2r
(detail explanations and a link to a sample file as well <g)

You should be able to grasp the suggested formula's workings (a single
formula in a starting cell of your choice, then straight copy down), and
modify accordingly to suit ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Omkar" wrote:
I have annual data for concentrations of various species for last
couple of years. I want to find out monthly (12 values) as well as
weekly averages(52 values) for these years.
I did it manually for one year, but its taking lot of time.

Can it be done using single formula and then copying it down the column
to get these values?

Please help me.

Thanks,
Omkar