Workday Calculation

In order to simplify workday/date calculations we've added two new functions to TeamDesk formula language, plus an option to database preferences.

Workdays(start, end, weekends)function calculates the number of work days between start and end dates inclusive, given the weekends specified by third argument.

For example, Workdays(#2015-08-12#, #2015-08-19#, "67") results to 6. This is an equivalent of NETWORKDAYS function in Excel.

Workday(start, days, weekends)function adds the number of work days to a start date, given the weekends specified by third argument.

For example, Workday(#2015-08-12#, 5, "67") results to #2015-08-19#. This is an equivalent of WORKDAY function in Excel.

Database preferences are now extended with Weekends option (Saturday, Sunday is the default) that will act as a default for weekends argument if omitted. Otherwise weekends is a string specifying either one or two digits in an 1..7 range to specify first and second weekend starting from Monday (1) to Sunday (7) or a "bitmap" consisting of exactly seven zeroes and ones, indicating whether the day is weekend (1) or not (0). Thus, classic Saturday-Sunday pair can be represented either as "67" or "0000011".

Enjoy!

Tweet about this on TwitterShare on Facebook0Share on Google+0