Date and Time - WeekendDays
Syntax: =WeekendDays(Date1, Date2 [, Weekend] )
Description: Return the number of weekend days in the date
interval.
Date1, Date2 : the date interval considered.
Weekend : Optional parameter to define the weekend. 1=Saturday and Sunday, 2=Sunday only
Example: =WeekendDays(A1,A2) =WeekendDays("01/June/2006","15/June/2006")
|