WeekdaysDiff ( startDate ; endDate ; format )

Returns the total number of weekdays (Monday to Friday) between the specified dates in the specified format.

Average rating: 4.3 (31 votes) Log in to vote

Kurt Otto - Show more from this author
ottopiaDESIGN
http://ottopia.dyndns.org/

Sample input:

WeekdaysDiff ( "10/4/2005" ; "27/9/2005" ; 0 )

WeekdaysDiff ( "10/4/2005" ; "27/9/2005" ; 1 )

Sample output:

5

-5

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

Case ( 

format = 1 ; 
If ( endDate < startDate ; 0 - Int ( ( startDate - endDate ) / 7 ) * 5 + Middle ( "0000000012345000123401112340122234012333401234440123455" ; ( DayOfWeek ( startDate ) *7 ) + Mod ( startDate - endDate ; 7 ) ; 1 ) ; Int ( ( endDate - startDate ) / 7 ) * 5 + Middle ( "00000001234550123444012333401222340111234000123400123450" ; ( DayOfWeek ( startDate ) *7 ) + Mod ( endDate - startDate ; 7 ) ; 1 ) ) ; 

If ( endDate < startDate ; Int ( ( startDate - endDate ) / 7 ) * 5 + Middle ( "0000000012345000123401112340122234012333401234440123455" ; ( DayOfWeek ( startDate ) *7 ) + Mod ( startDate - endDate ; 7 ) ; 1 ) ; Int ( ( endDate - startDate ) / 7 ) * 5 + Middle ( "00000001234550123444012333401222340111234000123400123450" ; ( DayOfWeek ( startDate ) *7 ) + Mod ( endDate - startDate ; 7 ) ; 1 ) )

)

Format
------
WeekdaysDiff ( startDate ; endDate ; format )

Parameters
----------
startDate - any date expression or field containing a date.
endDate - any date expression or field containing a date.
format - a number (0 or 1) that describes the display format

Data type returned
----------------
number

Description
----------
Returns the total number of weekdays (Monday to Friday) between the specified dates in the specified format.

0 - returns the absolute difference between the two dates.
1 - returns a negative value if the specifed end date occurs before the specified start date.

Examples
--------
This example assumes that the system date format is DD/MM/YYYY.

WeekdaysDiff ( "10/4/2005" ; "27/9/2005" ; 0 ) returns 5
WeekdaysDiff ( "10/4/2005" ; "27/9/2005" ; 1 ) returns -5

Comments

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

WeekdaysDiff ( startDate ; endDate ; format )

Comments

Support this website.

Support this website.