Return a Column Value Associated with a Max Date for a Client Within a Dynamic Date Range

I have found similar solutions to my problem online, but am not quite finding the exact scenario that I need to solve. I need unduplicated client counts across a few categories, but the clients can h...