Quick Openoffice question

Soldato
Joined
2 Sep 2006
Posts
13,483
Location
Forest Grove, OR, 'Merica
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
 
Last edited:
Well, you might try weeknum( datevalue(trim(A2)) )

If OOo doesn't have trim, substitute trim (A2) with your mid function

Hopefully OOo has the datevalue() function... if not I don't know :(

Edit: A2 contains your original date (change it of course)
 
Back
Top Bottom