DayCounter ( Date_Start ; Date_End ; Days_of_Week )

Counts number of times a day or days occurs over a date range

Average rating: 4.1 (41 votes) Log in to vote

Josh Morton - Show more from this author
JEM CONSULTING

Sample input:

_DayCounter ( Date ( 1 ; 1 ; 2010 ) ; Date ( 3 ; 31 ; 2010 ) ; "2¶4" )

Sample output:

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

/*_DayCounter ( Date_Start ; Date_End; Days_of_Week )

Author
Joshua Morton - JEM Consulting

Parameters
Date_Start - any calendar date;
Date_End - any calendar date;
Days_of_Week - a list of days of week (as numbers), separated by carriage returns (1=Sunday, 7 = Saturday).

Data type returned
number
Description
Returns a number counting only those days in the specified range whose day-of-week is included in the weekDays parameter.

Thanks to Michael Horak, *COMMENT Visual Realisation for their inspiration
July 28, 2010

*/

Case ( 
Date_Start and not IsEmpty ( FilterValues ( DayOfWeek ( Date_Start ) ; Days_of_Week ) ) ; 

1 )

 + 

Case ( 
Date_Start < Date_End ; 
_DayCounter ( Date_Start + 1 ; Date_End ; Days_of_Week  )

)

For example if you want to know how many Mondays and Wednesday occur between Jan 1st and March 31st. (For example in 2009 it was 25 in 2010 it as 26)

Comments

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

DayCounter ( Date_Start ; Date_End ; Days_of_Week )

Comments

Support this website.

Support this website.