WorkingDays ( )
Function stats
Average user rating
Support
FileMaker 9.0 +
Date posted
10 July 2010
Last updated
30 July 2010
Version
1.1 + View history
Recursive function
Yes
Function overview
Prototype
WorkingDays (
DateStart; DateEnd; HolidayList )
Parameters
DateStart
DateEnd
HolidayList
Description
Tags: Date
Returns the number of working days between the two dates w/o weekends and holidays.
All you need to do is create the holiday list.
Examples
Sample input
WorkingDays ( "07/07/2010" ; "07/07/2010" ; YourList )
Sample output
1
Function code
/*
WorkingDays ( DateStart ; DateEnd ; HolidayList )
returns the number of working days between the two dates.
No weekend days nor any day of the HolidayList
*/
Let (
$counter = $counter + ( Mod ( DateStart - 1 ; 7 ) < 5 and IsEmpty ( FilterValues ( DateStart ; HolidayList ) ) );
Case(
DateStart > DateEnd ; "" ;
DateStart = DateEnd ; $counter & Let( $counter = "" ; "" );
WorkingDays ( DateStart + 1 ; DateEnd ; HolidayList )
)
)
// ===================================
/*
This function is published on FileMaker Custom Functions
to check for updates and provide feedback and bug reports
please visit http://www.fmfunctions.com/fid/261
Prototype: WorkingDays( DateStart; DateEnd; HolidayList )
Function Author: Daniele Raybaudi (http://www.fmfunctions.com/mid/38)
Last updated: 30 July 2010
Version: 1.1
*/
// ===================================
WorkingDays ( DateStart ; DateEnd ; HolidayList )
returns the number of working days between the two dates.
No weekend days nor any day of the HolidayList
*/
Let (
$counter = $counter + ( Mod ( DateStart - 1 ; 7 ) < 5 and IsEmpty ( FilterValues ( DateStart ; HolidayList ) ) );
Case(
DateStart > DateEnd ; "" ;
DateStart = DateEnd ; $counter & Let( $counter = "" ; "" );
WorkingDays ( DateStart + 1 ; DateEnd ; HolidayList )
)
)
// ===================================
/*
This function is published on FileMaker Custom Functions
to check for updates and provide feedback and bug reports
please visit http://www.fmfunctions.com/fid/261
Prototype: WorkingDays( DateStart; DateEnd; HolidayList )
Function Author: Daniele Raybaudi (http://www.fmfunctions.com/mid/38)
Last updated: 30 July 2010
Version: 1.1
*/
// ===================================
Login or register to comment
Create a new account with fmcustomfunctions.com or login to post a comment.
