NETWORKDAYS Function: Difference between revisions

From Planfix
Jump to: navigation, search
(Created page with "The NETWORKDAYS function returns the number of workdays between "start_date" and "end_date," inclusive. Holidays and days off are not included. The account's default work hour...")
 
No edit summary
 
Line 10: Line 10:
   
   


'''Note'''
'''Note:'''
The function currently doesn't work for formulas calculated only for totals lines or the first groupings in reports.
The function currently doesn't work for formulas calculated only for totals lines or the first groupings in reports.



Latest revision as of 06:44, 21 December 2019

The NETWORKDAYS function returns the number of workdays between "start_date" and "end_date," inclusive. Holidays and days off are not included. The account's default work hours are used when calculating (first in the list of the account's work hours)


Format:

NETWORKDAYS(start_date;end_date)

where start_date and end_date are column or row names


Note: The function currently doesn't work for formulas calculated only for totals lines or the first groupings in reports.


Go To