Re: $$Excel-Macros$$ Formula to Calculate Networkdays

2012-12-13 Thread >>Excel Beginner<
Hi Manjunath, solved your query, please find the attachment. -- *Regards,* * * *Excel Beginner* * * On Thu, Dec 13, 2012 at 8:45 PM, Manjunath Narayanappa < manjunath.narayana...@aon.co.uk> wrote: > Hi experts, > > > > I want to calculate no of workdays and excludes holid

Re: $$Excel-Macros$$ Formula to Calculate Networkdays

2012-12-13 Thread Paul Schreiner
how did you (or did you) specify the holidays in the NetWorkdays function? Microsoft has no way of knowing what days YOU consider "holidays". Every country has their own "national" holidays. Employers may choose which of these holidays to "observe". So, Networkdays and NetWorkDays.intl have the a

Re: $$Excel-Macros$$ Formula to Calculate Networkdays

2012-12-13 Thread Divaker Pandey
use this one =NETWORKDAYS(DATEVALUE("12/24/2012"), DATEVALUE("12/28/2012"),A:A ) Let Range A:A contains list of holidays On Thu, Dec 13, 2012 at 8:47 PM, Manjunath Narayanappa < manjunath.narayana...@aon.co.uk> wrote: > > > Hi experts, > > > > I want to calculate no of workdays and excludes hol