I would want more notice, maybe a week or at least the weekend before. For the kids, it's like he is actually away, they won't see him. So there's that to deal with. My DDs can be a mess when DH is away, it happens so rarely they can barely handle it. (One is already freaking that he might, maybe, be gone for a week in October - yes that's in 6 months.)
OTOH, DH found out yesterday he has a late conference call and won't be home til 9ish tonight. It is what it is. But it sounds like your DH knew well in advance. He would have been better off going the "Oh sorry I thought I told you" route instead of saying you're making a big deal of it! That part just seems disrespectful and the combo of the two would leave me unhappy.
"Every mother needs a wife." - Amy Poehler, Yes Please