Quick Openoffice question

gurusan · 27 Dec 2012 at 01:52

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

gurusan · 28 Dec 2012 at 02:30

No one?

Sin_Chase · 28 Dec 2012 at 02:42

Opened it in LibreOffice (New Openoffice)

Returns week number fine....

gurusan · 28 Dec 2012 at 02:44

So it must be some general option that is set. :/

n3mss · 28 Dec 2012 at 02:45

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)

Sin_Chase · 28 Dec 2012 at 02:45

Potentially, regional settings?