ISWORKDAY Function: Difference between revisions
From Planfix
No edit summary |
No edit summary |
||
(3 intermediate revisions by the same user not shown) | |||
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 | This function returns the Boolean value "True" if a workday is found in a report column or analyzed in the field. The account's default [[Work calendar | work hours]] is used (the first in the account's list of work hours). Usually used with the [[IF Function]]. | ||
Line 11: | Line 11: | ||
''Examples:'' | ''Examples:'' | ||
(IF(ISWORKDAY(H);G;G*2) | (IF(ISWORKDAY(H); G; G*2) | ||
Latest revision as of 09:48, 20 November 2020
This function returns the Boolean value "True" if a workday is found in a report column or analyzed in the field. The account's default work hours is 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)