Hi All,

I need to calculate the number of working days between two given dates. For simplicity's sake I am assuming that working days are always Monday to Friday, ignoring weekends and any national holidays etc.

Basically, I want to enter a date in Date1 and a date in Date2 and have the result return the number of working days, including the two dates I entered.

Help much appreciated as always.

adapt this custom function to your needs

FileMaker Custom Function:WorkingDays ( DateStart ; DateEnd ; HolidayList )