AnsweredAssumed Answered

How to exclude weekends from date calculation

Question asked by muhammad.ikram@contedia.com 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.

Outcomes