Simple Last number lookup questiion

[thmehr]

HI
I tried to find a similar example in the forum but I was not able to find my example problem. I need to have cell at the end of a column of numbers that will pick the last available data input. There will be times when the cells within the column will not have a data point and there will be times when the data is not available since the data points are entered through the day. I need to know that last valid data point.If their is a skip in the data, would it be possible to say "n/a" ? I have attached a sample work sheet.
Thanks for you help in this matter.
Ted