Linker IT Software
Order Home
menubar-top-links menubar-top-rechts
SQL*XL: Database to Excel bridge ExcelLock: Lock and secure your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe
Home Products litLIB Help Date & Time functions

Buy now

Download now

LITlib - Excel Power Functions Pack
 
Add-in for Excel that adds additional cell functions to Excel.

litLIB Help - WeekendDays function
litLIB Help
Product pages :
litLIB
Quick links:
help index
forums

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")

litLIB