The 66-year-old musician and his wife Penny Lancaster, 39, welcomed their second child Aiden into the world on February 16 and the ‘Maggie May’ singer admits the tot is keeping them both awake at night.
When quizzed on how the baby was during an interview with Absolute Radio Breakfast Show host Christian O’Connell in the UK, he revealed: “I’m absolutely knackered, I don’t think I’ve had any sleep for two weeks.
“The first couple of nights Penny said, ‘Well go and sleep in another bedroom, there’s no point in two of us getting any sleep,’ but for the last 10 days we’ve been together.
“But she’s great, I wake up in the middle of the night and she hasn’t had any sleep and she’s feeding him and smiling. I don’t know how mothers do it, I tell you, it’s just phenomenal.”
With the addition of Aiden, Rod now has eight children but he insists he and Penny won’t be having anymore because the “office is closed”.
The singer – who also has a five-year-old son with the former model and six kids from previous relationships - said: “There’s eight, and that’s it now, the office is closed. She (Penny) agrees now, that’s it, you know, but I’m very proud of all my kids, they’re just tremendous.  Most of them live in California, I’ll be going back there on Sunday.”
It was announced that Rod will be headlining the Hard Rock Calling festival on Sunday June 26 in London’s Hyde Park.
He is joining the bill of the music event – which is now in its sixth consecutive year – along with Bon Jovi, who are topping the bill on Saturday June 25.
Rod is looking forward to the concert but is hoping it won’t rain on the day so everyone can have a good time in the sunshine.
He said: “I just hope it doesn’t rain, it always seems, when I do outside concerts, it p***es down with rain, so I’m really keeping my fingers crossed.
“It would be so lovely to go and have a beautiful sunset, I’m just praying for it, but it’ll be a great show.” 

Read more: Rod Stewart celebrates birth of new son and gives him an Irish name