Thanks you for finding time to solve my concern!

Attached is my sample file with actual formula.

i deleted 90% of data so file will be small enough to attach. But this is the actual file that I'm trying to work on.

The formula should calculate all the way down to the last row.

It also has a VBA for the dates.

Thank you so much!