AnsweredAssumed Answered

How to exclude weekends from date calculation

Question asked by on Jan 22, 2019
Latest reply on Jan 24, 2019 by a.k.

I have an order date and order sent date.


I have a report where I am calculating what is the time lapse between order date and order sent date.


My calculation simply says 'OrderSentDate' - 'OrderDate'. All works fine.


Now, this calculation also adds weekends days as well. Is there a way in way in FileMaker  I can exclude the weekend. So time lapse would just be based on weekdays number.


How would my new calculation be like.


Many Thanks.