AnsweredAssumed Answered

Calculating Business days

Question asked by MatthewMorgan_1 on Jul 17, 2015
Latest reply on Jul 25, 2015 by philmodjunk

Title

Calculating Business days

Post

Hello all!

Brand new to FM coming from an Excel VBA background, so i have some limited understanding of code. I have been trying to use the formula i find everywhere to calculate business days:

5 * Int ( ( Date End- Date Start) / 7 ) +Middle ( "0012345501234544012343340123223401211234010012340" ; 7 * (DayOfWeek ( Date Start) - 1 ) + DayOfWeek ( Date End) ; 1 )

The results are... sequential nonsense. 1 day separation = 7141, 2 days = 14287, and so on. I know I'm missing something dumb, i just cannot for the life of me figure it out. Any help would be greatly appreciated.

i have attached a sample image of the simple form I'm using.

 

Calc.JPG

Outcomes