Networkdays formula in MS Access

[phaniakella]

Dear Experts,

I have a table "LEAVE" with below columns. I want to derive number of working days between LEAVE_START_DATE and LEAVE_END_DATE. In excel this can be achieved care using NETWORKDAYS formula. Can you please guide me how to derive this value in ACCESS table? Thanks in advance.

EMPID

,EMPNAME,

LEAVE_START_DATE

,LEAVE_END_DATE,

NF_DAYS

<tbody>
</tbody><colgroup><col><col><col><col><col><col></colgroup>

 

[Joe4]

You need to create your own function in Access to mirror the Excel Networkdays function.
See: https://msdn.microsoft.com/en-us/library/dd327646(v=office.12).aspx
There is some code there which you should be able to copy and use.

 

[phaniakella]

Hi Joe

I have created a Temp access db and created a TEMP and Holidays table and used the macro suggested in the link https://msdn.microsoft.com/en-us/lib...ffice.12).aspx
This is not giving correct results. I think I am not doing this correctly. Can you please kindly guide me on where I am going wrong. Thanks in advance.

I have uploaded my Temp DB in below forum. Please kindly access the file from here and mail me back to email removed. I am not able to find provision to attach files in this forum. Thanks in advance.

Network Days module in Access not working as expected - Access World Forums

 

[Joe4]

I removed your email address from your last post. You never want to post your email address on a public internet forum, unless you really enjoyed receiving Spam/Junk Mail. Spambots often patrol internet forums looking for email addresses to harvest. If you ever have need to share an email address with someone, sending it via Private Message is the way to go.

I do not have the ability to download files from the internet at my current location (corporate security policy), but it looks like you already got a reply on that other website anyway. Please note that if you are going to Cross-Post (post the same question to multiple internet forums), that you heed our rules on that (which you kind of did incidentally).

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule #13 here: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered. For a more complete explanation on cross-posting, see here: Excelguru Help Site - A message to forum cross posters).