-
Find earliest and latest date in ranges with blanks
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,
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules