Depending on what SMS app you are using it should do this for you. I have used Handcent and am now using the stock messaging app. Both will give you that information.
Stock: Menu>Settings> Put a check in delivery reports you can also scroll down a bit more for more reports.
It's similar with handcent as well.