Saturday sunday & Holiday ommision

[Anonymous]

I want to excude saturday , sunday & Holiday from date interval-

Interval

(Resolved-[Requested Date],'d hhmm:ss')

Please help

[Roop]

use NetworkDays.

This will allow you to create the number of Monday to Friday days in your values together with a list of holiday dates at the end that will be excluded.

Hope this helps

[buzzy996]

networkdays( start_date, end_date {, holiday} )

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.

Example:

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

networkdays ('2006-12-18', '2006-12-31', '2006-12-25', '2006-12-

26') returns 8