Exclude weekend days

[Anonymous]

Hi all,

For the record below I want to exclude the weekend days.

Customer	start date	end days	# days (no weekend days)
a	7-1-2014	14-01-2014	6

Is the an easy way to solve this issue?

Best regards,

Arjan

[jagan · Accepted solution]

Hi,

Try NetWorkDay() for this

=NetWorkDays('1/7/2014', '1/14/2014')

Regards,

Jagan.

[Clever_Anjos]

=NetWorkDays(start_date,end_date) will return what you need

[sujeetsingh]

jagan so can you please explain the netWorkDays () function in detail

[jagan]

Hi Sujeet,

NetWorkdays() will receive Start and End date as parameters and returns the number of days between the two dates excluding Saturdays and Sundays.

Regards,

Jagan.

[MK_QSL]

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.

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