Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
litLIB: Sunday only weekends in Week(End)Days (Read 2365 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
litLIB: Sunday only weekends in Week(End)Days
03.08.11 at 13:04:04
 
litLIB: Sunday only weekends in Week(End)Days
 
Quote:
I want to calculate number of days between two dates leaving sunday only. there is nothing like this in this software.

 
The WeekDays function calculates the week days between two dates (not counting Saturday's and Sunday's). I have added an optional parameter to the WeekDay and WeekendDays functions to allow Sunday only weekends. This will give you the function you requested.
 
WeekDays(date1, date2, Weekend)
WeekendDays(date1, date2, Weekend)
 
Weekend = 1 : Saturday and Sunday weekend
Weekend = 2 : Sunday only weekend
 
Example:
WeekDays(A1,A2,2)
 
See also:
http://www.oraxcel.com/projects/litlib/help/weekdays.html
http://www.oraxcel.com/projects/litlib/help/weekenddays.html
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1