Yes, sorry, that's what I meant. :) (Or, ideally, just up to the last weekday of the last month of the reporting period, but either case is ok)

My mind is just drawing a serious blank on this task. But Date::Calc seems like an interesting place for me to start.