Calculating Business days
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.