How to truncate date
I get query data in the mm/dd/yyyy format. The YYYY starts out being every
year imaginable. I need to change long columns of cells so that the /yyyy
reads 2006. How do I do this?
Example (raw data)
01/15/2003
12/25/2005
03/19/1999
desired data
01/15/2006
12/25/2006
03/19/2006
|