ConditDateRange ( StartDate ; EndDate ; Weekend )
Date range that may include weekends or not.
Average rating: 4.4 (34 votes) Log in to vote
|Miguel Angel - Show more from this author|
12/09/2005(This result if the Weekend value is 1)
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
This custom function will return a list of dates from StartDate to EndDate. The Weekend parameter allows two values: 0 to omit weekends or 1 to include them.
Aug 15, 2012
|You're a god.
I love this so much. I have been struggling with a way to count the number of work days. This custom function, combined with value count works a treat.
Aug 18, 2012
|Thank you so much for your comment Peter.
Glad to see this custom funcion has been helpful for you.
|Dave Hobson, Bristol, UK
Dec 9, 2015
|Miguel - that's very helpful! Thanks for sharing it.
|Miguel, León / Spain
Feb 22, 2016
|You are welcome Dave,
Nice to see this function has been helpful once more.
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.