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)
amit.de...@merucabs.comwrote:
Dear All,
** **
For a
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