[Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register]

Author Message
shvitzer
Newbie

Joined: 06 May 2010
Posts: 1

 Posted: Thu May 06, 2010 9:31 am    Post subject: Week number to date conversion? HiAll, I am trying to convert the week number A1=27 and A2=2010 to an actual date, e.g. 1/10/2010 in A4. I found a formula that works in Excell but not in OpenOffice i.e. =A1*7+DATE(A2,1,1) I get error:5008 Doe anyone have a solution or another way of doing it? Thanks, Shvitzer
TessaES

Joined: 17 Feb 2007
Posts: 228
Location: Solna

 Posted: Thu May 06, 2010 11:14 am    Post subject: Calc uses a semicolon ( as a separator in formulas, not a comma
PromptJock
Super User

Joined: 26 Jul 2006
Posts: 741

Posted: Thu May 06, 2010 6:22 pm    Post subject:

 TessaES wrote: Calc uses a semicolon ( as a separator in formulas, not a comma

Tess: I tried to implement his formula in one of my calc sheets (using ";" for the ",", of course ) and all I got was an Err: 508 for my trouble.

The only thing I can think of is either the syntax is wrong or there's a fundamental error in our asker's basic formula...
_________________
I'm making perfect sense - you're just not keeping up!
ken johnson
Super User

Joined: 23 Apr 2009
Posts: 2032
Location: Sydney, Australia

Posted: Thu May 06, 2010 7:05 pm    Post subject:

PromptJock wrote:
 TessaES wrote: Calc uses a semicolon ( as a separator in formulas, not a comma

Tess: I tried to implement his formula in one of my calc sheets (using ";" for the ",", of course ) and all I got was an Err: 508 for my trouble.

The only thing I can think of is either the syntax is wrong or there's a fundamental error in our asker's basic formula...

I tried =A1*7+DATE(A2;1;1) using A1=27 and A2=2010 and it returns 9th July 2010.

Ken Johnson
_________________
PromptJock
Super User

Joined: 26 Jul 2006
Posts: 741

Posted: Fri May 07, 2010 2:42 pm    Post subject:

ken johnson wrote:
PromptJock wrote:
 TessaES wrote: Calc uses a semicolon ( as a separator in formulas, not a comma

Tess: I tried to implement his formula in one of my calc sheets (using ";" for the ",", of course ) and all I got was an Err: 508 for my trouble.

The only thing I can think of is either the syntax is wrong or there's a fundamental error in our asker's basic formula...

I tried =A1*7+DATE(A2;1;1) using A1=27 and A2=2010 and it returns 9th July 2010.

Ken Johnson

Glad to see someone got it to work.

For the record, I used an existing calc sheet rather than a "fresh" sheet, using "empty" cells in that sheet, and adjusting the formula to reference those cells. I still got the Err: 508, no matter what I tried.

Again, I DID NOT try was a fresh sheet, nor did I reformat the cells in my "test" sheet as "General". Maybe that's what's required for the formula to work???
_________________
I'm making perfect sense - you're just not keeping up!
ken johnson
Super User

Joined: 23 Apr 2009
Posts: 2032
Location: Sydney, Australia

Posted: Fri May 07, 2010 3:39 pm    Post subject:

 PromptJock wrote: Again, I DID NOT try was a fresh sheet, nor did I reformat the cells in my "test" sheet as "General". Maybe that's what's required for the formula to work???

I get Error 508: Missing Pair when I change the semicolon separating the 1st and 2nd arguments in the DATE function to a comma.
Are you sure there is no comma in your formula?
I can't see how formatting will cause error 508.

Ken Johnson
_________________
PromptJock
Super User

Joined: 26 Jul 2006
Posts: 741

Posted: Fri May 07, 2010 5:07 pm    Post subject:

ken johnson wrote:
 PromptJock wrote: Again, I DID NOT try was a fresh sheet, nor did I reformat the cells in my "test" sheet as "General". Maybe that's what's required for the formula to work???

I get Error 508: Missing Pair when I change the semicolon separating the 1st and 2nd arguments in the DATE function to a comma.
Are you sure there is no comma in your formula?
I can't see how formatting will cause error 508.

Ken Johnson

No, I made sure I replaced the commas with semicolons in the formula.

I'll try it again, making sure I Do Things Right on the formula.
_________________
I'm making perfect sense - you're just not keeping up!
PromptJock
Super User

Joined: 26 Jul 2006
Posts: 741

Posted: Mon May 10, 2010 12:21 pm    Post subject:

PromptJock wrote:
ken johnson wrote:
 PromptJock wrote: Again, I DID NOT try was a fresh sheet, nor did I reformat the cells in my "test" sheet as "General". Maybe that's what's required for the formula to work???

I get Error 508: Missing Pair when I change the semicolon separating the 1st and 2nd arguments in the DATE function to a comma.
Are you sure there is no comma in your formula?
I can't see how formatting will cause error 508.

Ken Johnson

No, I made sure I replaced the commas with semicolons in the formula.

I'll try it again, making sure I Do Things Right on the formula.

Well, I tried the formula again, using an "existing" sheet, but adjusting the cell references to point to the empty cells used AND a "virgin" sheet - I still get Err: 508 as a result.

I tried various formats for the target cell (Numbers, General; Date formats, etc.) but I still get the error.

For the record, my OOo is what was packaged with the Kubuntu 9.04 (Jaunty Jackalope) distribution I installed in the machine being used.

Is there a plugin I need or is this a "feature" of the particular OOo package I have?
_________________
I'm making perfect sense - you're just not keeping up!
 Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First
 All times are GMT - 8 Hours Page 1 of 1

 Jump to: Select a forum OpenOffice.org Forums----------------Setup and TroubleshootingOpenOffice.org WriterOpenOffice.org CalcOpenOffice.org ImpressOpenOffice.org DrawOpenOffice.org MathOpenOffice.org BaseOpenOffice.org Macros and APIOpenOffice.org Code Snippets Community Forums----------------General DiscussionSite Feedback
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum