As part of a larger vba project, I need to find the earliest date in a range and subtract from the latest date in another range to get the length of time (number of days). In addition, the range with the earliest date has blanks. Everything I've tried so far ends up with a 0. I know dates are tricky, but for the life of me I can't figure it out. I've tried min and max and mina and maxa, to no avail. I'd appreciate any pushes in the right direction.

thank you,