Forum Discussion
A M-Code equivalent for =NETWORKDAYS() in excel?
You would invoke it in your original table as Add Columns->Invoke Custom Function. Set each argument as column and use your start date column and end date column.
Edit: Or alternately use it in Advanced Editor, and pass on Start & End as variable (from calculation, another query etc).
Oh, custom function should be copied and pasted into new blank query (using advanced editor). Name it something that makes sense. (Ex: fnWorkday).
Hello again Chihiro,
Where should I insert your formula? Into a new custom column within Query Editor?
I am trying to avoid the creation of a new table with a row of dates - it seems a fairly inefficient way of doing something so I don't mind a function even if it is complex if it does the job in one column or measure!
:-)
Jemma
You would invoke it in your original table as Add Columns->Invoke Custom Function. Set each argument as column and use your start date column and end date column.
Edit: Or alternately use it in Advanced Editor, and pass on Start & End as variable (from calculation, another query etc).
Oh, custom function should be copied and pasted into new blank query (using advanced editor). Name it something that makes sense. (Ex: fnWorkday).