Date expressions that can exclude weekends

[Guest]

When using the expressions
Date()-1
and
[Date Completed]-[Date Received]
is there anyway I could get them to not count weekends?
Date()-1 works well until I need it to show Fridays totals on Monday.
[Date Completed]-[Date Received] I have to manually subtract if there is a
weekend involved.

 

[Jamie Collins]

When using the expressions
Date()-1
and
[Date Completed]-[Date Received]
is there anyway I could get them to not count weekends?

See:

Why should I consider using an auxiliary calendar table?
http://www.aspfaq.com/show.asp?id=2519

"A calendar table can make it much easier to develop solutions around
any business model which involves dates. Last I checked, this
encompasses pretty much any business model you can think of, to some
degree. Constant problems that end up requiring verbose, complicated
and inefficient methods include the following questions: How many
business days between x and y? ... As you can imagine, all of these
answers require complex iterative code that steps through and applies
logic to each of the dates in a range. Or do they...? "

Jamie.

--