I should also mention that I do have the start-end dates in the A (start
date) and B (end date) column in the same row as the calculation (column I)
on this worksheet. That means I could use those cells as reference instead
of DateValue if it would be easier?

Thanks,
Gina