On Tuesday, August 11, 2015 at 3:46:28 PM UTC+5:30, Claus Busch wrote:
Hi Nitya,

Am Tue, 11 Aug 2015 01:37:17 -0700 (PDT) schrieb Nitya Satheesh:

On Tuesday, August 11, 2015 at 11:34:03 AM UTC+5:30, Claus Busch wrote:
Hi Nitya,

Am Mon, 10 Aug 2015 22:07:49 -0700 (PDT) schrieb Nitya Satheesh:

Thanks Claus, but what I needed is,(and I don't think I explained that properly)is for it to show me the total number of days a grid has been sampled. so in my data if you look at grid 4 it worked from 10th to 17th so I would like the output to show me 8 days for jun-11 similarly for the other grid 1 it worked for 5 days in october-12(11th to 15th) and 10 days in jan-13(1st-10th)

now I got it ;-)
Please look again in OneDrive

Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

I'm so sorry, but if you don't mind , could you please explain the formula,I didn't quite get it.

In the E1:Z1 I have dates with always the first of month.In E2:E6 there
a the unique values of the grid.
In F2 I check if there is a Max if the grid in column A is the grid of
E2 and the month and the year in column B is month and year of F1.
If so I substract the Max with this conditions and the Min with this
conditions and add 1 for the start day because the difference is one day
less than the count of days.


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

Hi Claus,
Thanks for the explanation. I have one question - is it necessary to check if there is a max in f2? Can I directly check if the month and year of column b is the same as f1 then subtract the max and min with the same conditions you have provided? what is the reason for putting the max function?

Thanks again for the explanation !

Nitya