Linker IT Software
Order Home
menubar-top-links menubar-top-rechts
 

Software categories:
litLIB
Request new function
Download
Order
litLIB Help
Chemistry Functions
Date & Time Functions
Excel Functions
File System Functions
Logical Functions
Lookup Functions
Misc Functions
Numeric Functions
String Functions
System Functions
Web Functions
Vector and Matrix Functions
All Functions Index
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

Copyright (C) 1995-2010 Linker IT Software BV. All Rights Reserved. Oracle is a registered trademark of Oracle corporation. Excel and Office are registered trademarks of Microsoft corporation. Other names appearing on the site may be trademarks of their respective owners. Software, files, documents, articles and other material are provided "as is" and without warranties as to performance or mechantability or any other warranties whether expressed or implied. No warranty of fitness for a particular purpose is offered.
sitemap