ISWORKDAY Function: Difference between revisions
From Planfix
No edit summary |
No edit summary |
||
Line 1: | Line 1: | ||
This function returns the Boolean value "True" if a workday is found in a report column or analyzed field. The account's default [[work hours]] are used (the first in the account's list of work hours). Usually used with the [IF function]]. | This function returns the Boolean value "True" if a workday is found in a report column or analyzed the field. The account's default [[work hours]] are used (the first in the account's list of work hours). Usually used with the [[IF function]]. | ||
Revision as of 05:59, 21 December 2019
This function returns the Boolean value "True" if a workday is found in a report column or analyzed the field. The account's default work hours are used (the first in the account's list of work hours). Usually used with the IF function.
Format:
*ISWORKDAY(date)
Examples:
(IF(ISWORKDAY(H);G;G*2)