Outstanding Days exclude weekend Days (1 Viewer)

[Number11]

Hi I am trying to build a query that counts the number of days an order has been outstanding for using this

Outstanding For: IIf(DateDiff("d",[Created Time],Date())=0,2,DateDiff("d",[Created Time],Date()))

However its counting sat and sun days

 

[Gasman]

Well I was going to say check the similar threads below, but there are none?, but this question is asked time and time again, so I am puzzled as to why there are none?

This search link will give you some insight if not an answer, as the first link has a function?

HTH
https://www.access-programmers.co.uk/forums/search/12966/?q=count+days+less+weekends&o=relevance

I seem to recall that arnelgp also created a function for another member.

 

[jdraw]

You may get some ideas from this.