Need help in Net Working Days

[#1]

Hello Friends,

As I need to find the net working days of (RelDate), Saturday and Sunday will be holiday from the period of Oct 2011 to Sep 2012.

Can anybody help me...

Regards

Chriss

[Sokkorn · Accepted solution]

Hi Chriss,

Function Networkdays (start:date, end_date {, holiday})  will do this job.

Returns the number of working days (Monday-Friday) between and including start_date and end_date taking into account any optionally listed holidays. All parameters should be valid dates or timestamps.

Examples:

networkdays ('2007-02-19', '2007-03-01') returns 9 

networkdays ('2006-12-18', '2006-12-31', '2006-12-25', '2006-12-26') returns 8

Regards,

Sokkorn

[Anonymous]

Hi Chris,

Have you tried the NetWorkDays() function?

[#4]

Hello  Sokkorn and Johannes,

Thanks a lot.... its working fine..

Regards

Chriss

[rajni_batra]

hi,

This one is helpfull for you.

Regards

Rajni.