Hi sharad,
Find the attachment.
--
*Regards,*
*
*
*Excel Beginner*
On Sun, Sep 16, 2012 at 9:07 PM, sharad jain wrote:
> Dear Experts,
>
> Please help me in calculating operating days in the attached sheet.
>
> There are 2 contracts which will run after one after other. These
Hi Sharad,
Find the attachment.
--
*Regards,*
*
*
*Excel Beginner*
On Sun, Sep 16, 2012 at 9:07 PM, sharad jain wrote:
> Dear Experts,
>
> Please help me in calculating operating days in the attached sheet.
>
> There are 2 contracts which will run after one after other.
D10=MAX(0,MIN(D$8,$C2)-MAX($B2,D$7)+1)
And drag down and across
Regards,
Sam Mathai Chacko
On Sun, Sep 16, 2012 at 9:07 PM, sharad jain wrote:
> Dear Experts,
>
> Please help me in calculating operating days in the attached sheet.
>
> There are 2 contracts which will run after one after other.
