ISWORKDAY Function: Difference between revisions

From Planfix
Jump to: navigation, search
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 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]].
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)


Go To