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

  • Thread starter Thread starter David Dubroff
  • Start date Start date
D

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
 
David Dubroff said:
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?
Click to expand...

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
 
David said:
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?
Click to expand...


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.
 
Back
Top