| View previous topic :: View next topic |
| 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 |
|
| Back to top |
|
 |
TessaES
OOo Advocate
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 |
|
| Back to top |
|
|
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! |
|
| Back to top |
|
|
ken johnson
Super User
Joined: 23 Apr 2009
Posts: 1875
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
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button). |
|
| Back to top |
|
|
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! |
|
| Back to top |
|
|
ken johnson
Super User
Joined: 23 Apr 2009
Posts: 1875
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
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button). |
|
| Back to top |
|
|
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! |
|
| Back to top |
|
|
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! |
|
| Back to top |
|
|
|
