Brian Dunning's FileMaker Custom Functions

Weekdays ( StartDate ; EndDate )

Weekdays between start date and end date.

  Average rating: 4.4 (39 votes) Log in to vote

John Fitch   John Fitch
Database Solutions
www.briandunning.com

Share on Facebook Share on Twitter

  Sample input:
Weekdays ( StartDate , EndDate )
  Sample output:
261

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

Gives the number of weekdays between a start and end date. I've been using this equation since 1995 and it has always been correct.

 

Comments

Hugh   Hugh, Rapid City, SD
Sep 28, 2010
Thanks
 
John Fitch   John Fitch, Edmond
Sep 28, 2010
I've been using this equation to determine weekdays between a start date and an end date since 1995 and it has never failed me. I write activity based accounting software. This is the custom function version of the equation.
 

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.