How to Calculate Work Days Between Two Dates in Microsoft Access. Similar to Excel NETWORKDAYS.

[@599CD]

ADDENDUM: There is a tiny bug in the code. See 599cd.com/WorkDays for the fix.

[@DavidDunster]

I have been a user of Access since day one. Love the application like it was my own child. I'm 70 years old and still design databases for my personal needs. Thank you for this video.

[@bikswahla]

Thanks for your lesson on this, when I have the code in and running a query its giving me an error " Undefined function "MyNetWorkDays' in expression. can you help with this?

[@modupeletsie5133]

Dear Richard, Thanks for the excellent video. I did exactly as you explained in the video but get message saying that Undefined function "MyNetWorkDays" in expression. What is the problem/solution.

[@599CD]

You didn't create the function right. Try again.

[@biatcet118]

Please make a video about how to do advanced calculated query from 2 or more fields using the builder.

[@599CD]

I don't use the builder.

[@biatcet118]

@@599CD or use vba code or anything that can perform complex calculated query.

[@MuhammadZubair-441]

sir i want that how to custom text on next field. example "dateofenrollment" first field and next field auto text of 1 year diffrence and next field auto text 2 years diffrence and next field auto text 3 years diffrence...and so on

[@sandraj6264]

How would I set the code to count all calendar days instead of just business days?

[@599CD]

599cd.com/DateDiff or just 599cd.com/DateMath

[@akokohjoel9854]

Firstly i appreciate you for your video. You are the ORACLE of ms access in our generation. Observation Mr rost, on excel the working was 22day but on ms access why is it 21day? If you count manually with a calendar excel 22days is correct. But is ms access on query give 21day. Pls Mr rost can you explain why? Thanks

[@599CD]

Always check the description text below the video for addendums. 599cd.com/WorkDays