OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Week number to date conversion?

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
shvitzer
Newbie
Newbie


Joined: 06 May 2010
Posts: 1

PostPosted: Thu May 06, 2010 9:31 am    Post subject: Week number to date conversion? Reply with quote

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
View user's profile Send private message
TessaES
OOo Advocate
OOo Advocate


Joined: 17 Feb 2007
Posts: 228
Location: Solna

PostPosted: Thu May 06, 2010 11:14 am    Post subject: Reply with quote

Calc uses a semicolon (Wink as a separator in formulas, not a comma
Back to top
View user's profile Send private message
PromptJock
Super User
Super User


Joined: 26 Jul 2006
Posts: 741

PostPosted: Thu May 06, 2010 6:22 pm    Post subject: Reply with quote

TessaES wrote:
Calc uses a semicolon (Wink 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 Wink ) 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
View user's profile Send private message
ken johnson
Super User
Super User


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

PostPosted: Thu May 06, 2010 7:05 pm    Post subject: Reply with quote

PromptJock wrote:
TessaES wrote:
Calc uses a semicolon (Wink 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 Wink ) 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
View user's profile Send private message
PromptJock
Super User
Super User


Joined: 26 Jul 2006
Posts: 741

PostPosted: Fri May 07, 2010 2:42 pm    Post subject: Reply with quote

ken johnson wrote:
PromptJock wrote:
TessaES wrote:
Calc uses a semicolon (Wink 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 Wink ) 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. Smile

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
View user's profile Send private message
ken johnson
Super User
Super User


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

PostPosted: Fri May 07, 2010 3:39 pm    Post subject: Reply with quote

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
View user's profile Send private message
PromptJock
Super User
Super User


Joined: 26 Jul 2006
Posts: 741

PostPosted: Fri May 07, 2010 5:07 pm    Post subject: Reply with quote

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. Smile
_________________
I'm making perfect sense - you're just not keeping up!
Back to top
View user's profile Send private message
PromptJock
Super User
Super User


Joined: 26 Jul 2006
Posts: 741

PostPosted: Mon May 10, 2010 12:21 pm    Post subject: Reply with quote

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. Smile

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
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
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


Powered by phpBB © 2001, 2005 phpBB Group