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 - WeekDays function
litLIB Help
Product pages :
litLIB
Quick links:
help index
forums

Date and Time - WeekDays

Syntax:
=WeekDays(Date1 , Date2 [, Weekend] )

Description:
Returns the number of week days between the two dates.

Date1, Date2 : the dates that determine the interval to consider.
Weekend : Optional parameter to define the weekend. 1=Saturday and Sunday, 2=Sunday only

Example:
=WeekDays(A1,A2)
=WeekDays("01/June/2006","15/June/2006")

litLIB