Finding Workdays prior to a date

A

AccessQuestion

In Access, is there a function that will allow a user to calculate the numer of weekdays (Mon-Friday) prior to a given date? Like WORKDAY in Excel.
 
D

Douglas J. Steele

Take a look at the Date/Time section of "The Access Web"
http://www.mvps.org/access/

There are a couple of solutions there.

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)



AccessQuestion said:
In Access, is there a function that will allow a user to calculate the
Click to expand...
numer of weekdays (Mon-Friday) prior to a given date? Like WORKDAY in
Excel.
 
A

AcessProgrammer

Thank you very much. I'm disappointed that MS Access has such limited Date Functionality when Excel functions are so abundant. The tip you gave was very helpful.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help using the Workday Function 1
Calendar Logic: Recurring Dates 3
Adding days to the WORKDAY function 2
Finding second-to-last workday of month 4
Workday function question 2
Advanced use of WORKDAY function 4
How to make Friday as weekend instead of Sat/Sun in Workday Functi 11
Calculate next workday after adding calendar days to date in cell 13

Top