Thanks Brian. This helped allot and worked. I read something on Google about commas but it didn't make sense due to the poor language used.
Sorry, but I am new to the forum so I am not aware of the Calc Manual. Anyway, this is now resolved. Much appreciated. Mark. -----Original Message----- From: Brian Barker [mailto:[email protected]] Sent: Friday, 8 September 2017 3:33 PM To: [email protected] Cc: Mark Messiha <[email protected]> Subject: Re: Error 508 With Open Office When Using Edate Formula At 04:15 08/09/2017 +0000, Mark Messiha wrote: >I have a client who uses Open office. I need to use formula Edate to >calculate some dates. When doing so, I get error 508. >The formula is as follows: =edate(r2, 9) or =edate(r2, 12). Can anyone >tell me why I get error code 508 and what I can do to fix it? OpenOffice uses a semicolon, not a comma, as a parameter separator in spreadsheet formulae. Use =EDATE(R2;9) and so on instead. >I have done the following: >* Uninstalled Open Office >* Rebooted my PC >* Run CCLeaner >* Rebooted my PC again >* Reinstalled the latest version of Open office You could have read the Calc Manual, which says "*Note* OOo uses the semicolon as an argument list separator, unlike Excel which uses a comma. This is a common mistake made by users accustomed to entering Excel formulas." I trust this helps. Brian Barker --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
