By Richard Rost 2 years ago
How to Find the First Monday of any Month
In this video, I'll show you how to find the first Monday of any given month. You can then, of course, very easily use the same technique to find the first of any given weekday in that month (Monday - Sunday).
Alissa from Ottawa, Ontario, Canada (a Silver Member) asks: I need to be able to find the first Monday of any given month to determine what the first work day is. How can I do this in Access?
Silver Members and up get access to an Extended Cut of this video. Members will learn how to calculate the Nth weekday of any given month, such as the second Monday or the fourth Saturday.
Teeka from Shelby, North Carolina (a Platinum Member) asks: Is there any way you can find the Nth weekday of any given month, for example the 1st Monday in June 2021, or the 4th Wednesday in August 1999?
Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the database template from class plus get access to the Code Vault. If you signed up on YouTube you have to register on my YouTube Find User page so I can set up your account here on my web site. If you're not a member, Join Today!
microsoft access, ms access, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #instruction, #learn, #lesson, #training, #database, first monday of the month, nth day of any month, dateserial, weekday, vbMonday
Subscribe to First Monday
Get notifications when this page is updated