Hi macropod,

Thanks for helping. I read up on the MOD formula, and I'm confused as to how this would work for what I'm trying to do?

Let me try to explain the fixed payment ordeal in a different way.

Say I have a periodic payment on the 10th. If the 12th is the Friday of the week and it contains the 10th, I want that value to appear. For other Friday's such as the 19th and the 10th doesn't fall within that week, then no value appears in that cell.