Now this formula works! It didn't work until after I rebooted my system! But at least it does work. And since I was so proud of myself, I added a 2nd formula in the cell below this one that calculates for a range of dates:
I am glad I was able to solve this one on my own. But that is only because I spend so much time reading everyone elses posts! Thanks again everyone. I figured I would post my additional formula on the off chance it can be helpful to someone else.