The current date/time stamp is below:
9/2/2009 8:59PM
I need to keep the date but remove the time stamp on the data. I have been using the formula below:
=MONTH(A1) & "/" & DAY(A1) & "/" & YEAR(A1)
But now it is giving me a !value error. Can anyone help? THanks!
Bookmarks