AnsweredAssumed Answered

WorkDays

Question asked by user28271 on Jul 6, 2018
Latest reply on Jul 10, 2018 by fmpdude

I found this equation on line which will return the total number of work day between two dates.

 

5 * Int ( ( EndDate - StartDate ) / 7 ) +Middle ( "0012345501234544012343340123223401211234010012340" ; 7 * (DayOfWeek ( StartDate ) - 1 ) + DayOfWeek ( EndDate) ; 1 )

 

But if I do 1/1/2018 to 12/31/2018 I get 260 day when it should be 261.

 

Anyone know why?

Outcomes