You're absolutely correct. I'm only really interested in whole months. The other solutions are equally workable but you've pointed out something I hadn't thought of: we're not quite at the end of the month. So, I think your solution will probably nail it for me most accurately.

Thanks to all who responded!