So I have a column, each cell in the column has dates in it but there is a space before and after the date...such as " 12/26/2012 ".
I am trying to return the week number of every cell in that column....so I am using the MID function to trim the date string to a valid date, and the WEEKNUM function to return the week number. I am only getting #VALUE. What am I doing wrong!???!?
Here is an example of what I am trying to do...I'm trying to return the week number in column J:
https://docs.google.com/file/d/0B8BEOxpy2mm5RVhfcEtMcTFYZ2s/edit
Thanks in advance
I am trying to return the week number of every cell in that column....so I am using the MID function to trim the date string to a valid date, and the WEEKNUM function to return the week number. I am only getting #VALUE. What am I doing wrong!???!?
Here is an example of what I am trying to do...I'm trying to return the week number in column J:
https://docs.google.com/file/d/0B8BEOxpy2mm5RVhfcEtMcTFYZ2s/edit
Thanks in advance
Last edited: