For the record below I want to exclude the weekend days.
|Customer||start date||end days||# days (no weekend days)|
Is the an easy way to solve this issue?
NetWorkdays() will receive Start and End date as parameters and returns the number of days between the two dates excluding Saturdays and Sundays.
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.
networkdays ('2007-02-19', '2007-03-01') returns 9
networkdays ('2006-12-18', '2006-12-31', '2006-12-25', '2006-12-26') returns 8