On Tuesday, August 11, 2015 at 4:44:59 PM UTC+5:30, Claus Busch wrote:
Hi Nitya,

Am Tue, 11 Aug 2015 04:00:51 -0700 (PDT) schrieb Nitya Satheesh:

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?

if you e.g. have 10.06.2015 until 17.06.2015 and you substract Max with
Min you get 7 but there are 8 days. So you have to add 1. If you don't
check for Max and directly calculate Max-Min+1 you get the wrong result
of 1 if there are no days with the conditions.


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

Thanks a lot Claus!!! This helped me a lot !