Dear All,
For a calculation of TAT, I wanted to make excel treat each day as working
days..Currently excel considers 5 days as working days.. I want to change the
logic to all 7days as working days & will add any applicable Sunday as holiday..
Please help me if any setting needs to be changed f
if u are using 2010 then you can use NETWORKDAYS.INTL
other wise
use sumproduct (=(G2-F2)-SUMPRODUCT((HOliday>=F2)*(HOliday<=G2)))
holiday list as per your requirement
Thanks
XLS S
On Thu, Jan 24, 2013 at 3:19 PM, Amit Desai (MERU)
wrote:
> Dear All,
>
> ** **
>
> For a calculation of TA