G Guest Apr 30, 2004 #1 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.
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 Apr 30, 2004 #2 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.
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.
G Guest May 4, 2004 #3 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.
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.
