Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
BlakeT
Contributor
Contributor

current work day .

I am trying to measure if a report is submitted by a certain work day . I am not sure how to do this .

example:

mydatefield = 2019/04/12. I want to measure if the report was submitted before the 10th work day .

I am able to figure out network days: 23  and day number : 12 . However , what needs to be calculated is the day number in relation to the networkdays ie :  the 12th of April is actually the 10th working day of the month and it is this that I need to calculate.

 

Labels (3)
1 Reply
dplr-rn
Partner - Master III
Partner - Master III

use networkdays function. e.g. below
NetWorkDays(Date#('2019/04/01','YYYY/MM/DD'),Date#('2019/04/12','YYYY/MM/DD')) returns 10

so maybe in your case
NetWorkDays(MonthStart(YOURDATEFIELD),YOURDATEFIELD)