When does the sleep deprivation actually get better?

My son is 3 weeks old and I'm absolutely wrecked. My wife and I are taking shifts at night but I feel like I'm losing my mind. I keep nodding off at my desk at work and almost crashed the car yesterday. Is this normal? When can I expect to actually sleep more than 45 minutes at a time? Honestly wondering how I'm still functioning.