Uploaded August 2026 | Updated September 2026, 2 weeks ago
In this lesson, we will calculate overlapping days between two date ranges in Microsoft Access. I will show you how to find the later start date and earlier end date, return zero when ranges do not overlap, and count days using inclusive or exclusive endpoints. We will create a reusable VBA function, test it with several date-range scenarios, and correct a common copy-and-paste comparison error.
Timothy from Sioux Falls, South Dakota (a Platinum Member) asks I'm building a database to split utility bills between tenants who move in and out. I have two different date ranges, and I need to know how many days they overlap. Is there an easy way to calculate that in Microsoft Access?
Silver Members & up get access to an Extended Cut of this video. In the extended cut, we will build a utility bill calculator that loops through each billing-period day, determines which tenants were active, splits the daily cost among them, and totals what each tenant owes. We will work with recordsets, loops, updating table data, move-in and move-out dates, and a query to show each tenant's amount due.
MEMBERS-ONLY EXTENDED CUT VIDEO:
youtu.be/e2vDHDEJyus
CHAPTERS:
00:00 Introduction
01:40 Understanding Date Range Overlaps
06:11 Prerequisites
06:52 Building The OverlapDays Function
14:42 Testing The Function
15:26 Debugging A Copy-And-Paste Error
19:49 Extended Cut: Utility Bill Calculator
21:26 Recommended Courses
21:45 Conclusion
BECOME A MEMBER:
YouTube: youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/join
or My Site: 599cd.com/THMember
LEARN MORE:
Overlapping Days: 599cd.com/OverlappingDays
PREREQUISITES:
Intro to VBA: 599cd.com/VBA
Create Function: 599cd.com/Function
Date Math: 599cd.com/DateMath
Status Box: 599cd.com/Status
LINKS:
Original Forum Thread: 599cd.com/a?99938
DateDiff: 599cd.com/DateDiff
Work Days: 599cd.com/WorkDays
Prorated: 599cd.com/Prorated
Date Criteria: 599cd.com/DateCriteria
Date Only: 599cd.com/DateOnly
Table-Level Validation: 599cd.com/TLValidation
RECOMMENDED COURSES:
Date Functions in Access Expert 27: 599cd.com/ACX27
Date Math in Access Expert 28: 599cd.com/ACX28
VBA Basics in Access Developer 1: 599cd.com/ACD1
Functions and Parameters in Access Developer 25: 599cd.com/ACD25
Access DateTime Seminar: 599cd.com/DateTime
Reservation Conflicts in Access Developer 24: 599cd.com/ACD24
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: 599cd.com/THFree
Blank Template: 599cd.com/Blank
Contact Management: 599cd.com/Contacts
Order Entry & Invoicing: 599cd.com/Invoicing
More Access Templates: 599cd.com/AccessTemplates
DIAMOND SPONSORS:
More info on our Sponsors: 599cd.com/DiamondSponsors
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: 599cd.com/Free1
How to Use Access in 30 Minutes: 599cd.com/30Minutes
$1 Access Level 2: 599cd.com/1Dollar
Donate to my Tip Jar: 599cd.com/TipJar
Merch Store! Get your swag here: 599cd.com/Merch
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/TechHelp
Consulting Help: 599cd.com/DevNet
Twitter: twitter.com/LearningAccess
en.wikipedia.org/wiki/Microsoft_Access
products.office.com/en-us/access
microsoft.com/en-us/microsoft-365/blog/access
KEYWORDS:
TechHelp, Access 2016, Access 2019, Access 2021, Access 2024, Access 365, Microsoft Access, MS Access, MS Access Tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, Access VBA date range overlap, calculate overlapping days, overlapping date ranges, date range intersection, inclusive date range, VBA date math, reservation conflict detection, rental billing period, utility bill tenant split, DateDiff alternatives
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Live long, and prosper.
In this lesson, we will calculate overlapping days between two date ranges in Microsoft Access. I will show you how to find the later start date and earlier end date, return zero when ranges do not overlap, and count days using inclusive or exclusive endpoints. We will create a reusable VBA function, test it with several date-range scenarios, and correct a common copy-and-paste comparison error.
Timothy from Sioux Falls, South Dakota (a Platinum Member) asks I'm building a database to split utility bills between tenants who move in and out. I have two different date ranges, and I need to know how many days they overlap. Is there an easy way to calculate that in Microsoft Access?
Silver Members & up get access to an Extended Cut of this video. In the extended cut, we will build a utility bill calculator that loops through each billing-period day, determines which tenants were active, splits the daily cost among them, and totals what each tenant owes. We will work with recordsets, loops, updating table data, move-in and move-out dates, and a query to show each tenant's amount due.
MEMBERS-ONLY EXTENDED CUT VIDEO:
youtu.be/e2vDHDEJyus
CHAPTERS:
00:00 Introduction
01:40 Understanding Date Range Overlaps
06:11 Prerequisites
06:52 Building The OverlapDays Function
14:42 Testing The Function
15:26 Debugging A Copy-And-Paste Error
19:49 Extended Cut: Utility Bill Calculator
21:26 Recommended Courses
21:45 Conclusion
BECOME A MEMBER:
YouTube: youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/join
or My Site: 599cd.com/THMember
LEARN MORE:
Overlapping Days: 599cd.com/OverlappingDays
PREREQUISITES:
Intro to VBA: 599cd.com/VBA
Create Function: 599cd.com/Function
Date Math: 599cd.com/DateMath
Status Box: 599cd.com/Status
LINKS:
Original Forum Thread: 599cd.com/a?99938
DateDiff: 599cd.com/DateDiff
Work Days: 599cd.com/WorkDays
Prorated: 599cd.com/Prorated
Date Criteria: 599cd.com/DateCriteria
Date Only: 599cd.com/DateOnly
Table-Level Validation: 599cd.com/TLValidation
RECOMMENDED COURSES:
Date Functions in Access Expert 27: 599cd.com/ACX27
Date Math in Access Expert 28: 599cd.com/ACX28
VBA Basics in Access Developer 1: 599cd.com/ACD1
Functions and Parameters in Access Developer 25: 599cd.com/ACD25
Access DateTime Seminar: 599cd.com/DateTime
Reservation Conflicts in Access Developer 24: 599cd.com/ACD24
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: 599cd.com/THFree
Blank Template: 599cd.com/Blank
Contact Management: 599cd.com/Contacts
Order Entry & Invoicing: 599cd.com/Invoicing
More Access Templates: 599cd.com/AccessTemplates
DIAMOND SPONSORS:
More info on our Sponsors: 599cd.com/DiamondSponsors
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: 599cd.com/Free1
How to Use Access in 30 Minutes: 599cd.com/30Minutes
$1 Access Level 2: 599cd.com/1Dollar
Donate to my Tip Jar: 599cd.com/TipJar
Merch Store! Get your swag here: 599cd.com/Merch
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/TechHelp
Consulting Help: 599cd.com/DevNet
Twitter: twitter.com/LearningAccess
en.wikipedia.org/wiki/Microsoft_Access
products.office.com/en-us/access
microsoft.com/en-us/microsoft-365/blog/access
KEYWORDS:
TechHelp, Access 2016, Access 2019, Access 2021, Access 2024, Access 365, Microsoft Access, MS Access, MS Access Tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, Access VBA date range overlap, calculate overlapping days, overlapping date ranges, date range intersection, inclusive date range, VBA date math, reservation conflict detection, rental billing period, utility bill tenant split, DateDiff alternatives
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Live long, and prosper.
