Timestamp date stays 12:00:00

I've attached the file.

Macro wasn't set up yet....pay no mind to that.

Everything I can think of checking, always ends up with the same result...12:00:00.

There's info (date) in the referred cell.

I also realize that the formula given was not the same cells as what I have here - I was just trying to keep it generic.

Thanks for your help everybody!!