ISWORKDAY Function: Difference between revisions
From Planfix
(Created page with "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'...") |
No edit summary |
||
| (4 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 5: | Line 5: | ||
''Format:'' | ''Format:'' | ||
''*ISWORKDAY(date)'' | '''*ISWORKDAY(date)''' | ||
| 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)