MSAC2K -- Calculating number of week days from a date...

[David Dubroff]

Microsoft Access 2000 Question:

What is the formula to find out the number of week days from a date stored
in the system to today's date (skipping Saturday and Sunday) ?

[Today's date] minus [date value] = "x" number of days (skipping Saturday
and Sunday)

What would the formula be to perform this calculation?

Thanks in advance...
Dave

 

[Dirk Goldgar]

Microsoft Access 2000 Question:

What is the formula to find out the number of week days from a date
stored in the system to today's date (skipping Saturday and Sunday) ?

[Today's date] minus [date value] = "x" number of days (skipping
Saturday and Sunday)

What would the formula be to perform this calculation?

There's no built-in function, but fortunately others have done the heavy
lifting for us. To do workday math, use the functions posted here:

http://www.mvps.org/access/datetime/date0012.htm

 

[Marshall Barton]

Microsoft Access 2000 Question:

What is the formula to find out the number of week days from a date stored
in the system to today's date (skipping Saturday and Sunday) ?

[Today's date] minus [date value] = "x" number of days (skipping Saturday
and Sunday)

What would the formula be to perform this calculation?

This article shows a way to do that:
http://www.mvps.org/access/datetime/date0006.htm
but you want to modify it to avoid the English day names.