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 email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.