Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Try NetWorkDay() for this
=NetWorkDays('1/7/2014', '1/14/2014')
Regards,
Jagan.
Hi,
Try NetWorkDay() for this
=NetWorkDays('1/7/2014', '1/14/2014')
Regards,
Jagan.
=NetWorkDays(start_date,end_date) will return what you need
jagan so can you please explain the netWorkDays () function in detail
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.
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