Thanks for your reply. For some reason that's not working. I've even tried taking the formatting off the target cell and tried formatting it as text and general. Even then, entering 3/14/81 into that cell, although it displays as such, shows 3/14/1981 in the formula bar. So it changes my input and no matter what I do to my formula, it reads that as 29659 in my destination cell. I also noticed that when I enter a date in the target cell it changes the formatting to date (which is a bit annoying)

Any thoughts?

Thanks again.