Brian Dunning's FileMaker Custom Functions

CountWorkingDays ( DateStart ; DateEnd )

Returns the number of working days between two dates.

  Average rating: 4.5 (13 votes) Log in to vote

Cristos Lianides-Chin   Cristos Lianides-Chin
Anchor-Buoy Software, LLC
http://www.anchorbuoysoftware.com

Share on Facebook Share on Twitter

  Sample input:
$example1 = CountWorkingDays ( "7/18/2016" ; "7/20/2016" )
$example2 = CountWorkingDays ( "7/20/2016" ; "7/18/2016" )
  Sample output:
$example1 = 2
$example2 = -2

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Returns the number of working days between two dates:
* if DateStart is BEFORE DateEnd, returns a positive number
* if DateStart is AFTER DateEnd, returns a negative number

 

Comments

Log in to post comments.

 

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

Under construction. Email me your wish list for improvements.