Newest functions Upload a function Leave a tip My account

There are 2,520 functions in this library.

Weekdays ( StartDate ; EndDate )

Weekdays between start date and end date.

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

John Fitch Database Solutions www.briandunning.com

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

( EndDate + 1 - StartDate ) - Int (( EndDate + 1 - StartDate)/7) * 2 - Case ( Mod (EndDate + 1 - StartDate ; 7) = 0 or DayName ( StartDate ) = "Monday" and Mod (EndDate + 1 - StartDate ; 7) < 6 or DayName ( StartDate ) = "Tuesday" and Mod (EndDate + 1 - StartDate ; 7) < 5 or DayName ( StartDate ) = "Wednesday" and Mod (EndDate + 1 - StartDate ; 7) < 4 or DayName ( StartDate ) = "Thursday" and Mod (EndDate + 1 - StartDate ; 7) < 3 or DayName ( StartDate ) = "Friday" and Mod (EndDate + 1 - StartDate ; 7) < 2 ; 0 ; DayName ( StartDate ) = "Sunday" or DayName ( StartDate ) = "Monday" and Mod (EndDate + 1 - StartDate ; 7) = 6 or DayName ( StartDate ) = "Tuesday" and Mod (EndDate + 1 - StartDate ; 7) = 5 or DayName ( StartDate ) = "Wednesday" and Mod (EndDate + 1 - StartDate ; 7) = 4 or DayName ( StartDate ) = "Thursday" and Mod (EndDate + 1 - StartDate ; 7) = 3 or DayName ( StartDate ) = "Friday" and Mod (EndDate + 1 - StartDate ; 7) = 2 or DayName ( StartDate ) = "Saturday" and Mod (EndDate + 1 - StartDate ; 7) = 1 ; 1 ; 2 ) Click to copy

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, Rapid City, SD Sep 28, 2010
Thanks

		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.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 20 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: