We often have to calculate the number of overlapping days in two date ranges. For example: How many days of my vacation overlap with your vacation? Here's a LotusScript function we came up with to do this. It exploits some of the formula language's built in functions. We're only interested in whole days of overlap, but you could adapt it for time ranges as well.
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.