networkdays.intl in excel 2007

[zoharb]

Respected ,
How to use networkdays. intl in --excel 2007(here only networkdays formula is available which has default to sat, sun-system date)
as here weekly off is friday, so weekends can be counted as thu,fri
here we cant change system data from GMT+5.30 and weekends as sat, sun as it will create issues in accounting files.
But the work is outsourced so has to keep a tab on employees working at a remote place.
like fri, sat there are various combinations like wed-thu and so on.
Zohar Batterywala

 

[arun_eagertolearn]

Hi

Please try offsetting by 2 days
Sat, Sun are 2 days after Thu, Fri
Eg: If you need to find working days between A and B, please try finding out between A+2 and B+2 with the NETWORKDAYS formula

 

[MARK858]

@zoharb have a look at the thread in the link below

need VBA code for networkdays.intl to use in excel 2007

Hi, I need a VBA code for networkdays.intl so that I can use this function in excel 2007. I am using 2007 in office and home. If somebody can help me it will be greatly appriciated. Thanks.

www.mrexcel.com