cros@googlegroups.com
Subject: Re: FW: $$Excel-Macros$$ Calculate Net TAT / time Gap excluding
Holidays as per list
use sumproduct (=(G2-F2)-SUMPRODUCT((HOliday>=F2)*(HOliday<=G2)))
holiday list as per your requirement
On Mon, Jan 28, 2013 at 12:36 PM, Amit Desai (MERU)
mailto:amit.de...@me
Best Regards,
>
> Amit Desai
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Amit Desai (MERU)
> *Sent:* 26 January 2013 10:44
> *To:* excel-macros@googlegroups.com
> *Subject:* FW: $$Excel-Macros$
Dear Friends,
Please help.
Best Regards,
Amit Desai
+91 98672 32534
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Amit Desai (MERU)
Sent: 25 January 2013 13:57
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Calculate Net TAT / time Gap excl
