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.