On 04/21/2008 10:08 AM, Jerry Feldman wrote: > I routinely take Excel spreadsheets and convert them to Calc. The > spreadsheets are functional specifications for a product I am working > on. The problem is there are a number of columns that use date > calculations that require the Excel DATEDIF() function. > OpenOffice.org have roughly functions such as YEARS(). The ODF > specification (ISO/IEC 26300:2006 Open Document Format for Office > Applications (OpenDocument) v1.0) does define the DATEDIF() function > AFAIK. Actually, it is a minor pain to convert these as the total > time is about 5 mins a couple of times a month. Actually, GNUMeric > support datedif() but GNUMeric is not supported on RHEL 4 Update 3 > that I am required to run. One of the big benefits for the spec > writer using Excel and me using OO.o is that it catches some errors. > The person writing the spec could use OO.o since it is installed on > her Windows laptop, but others in the company only use Excel so we do > need to maintain the document in MS .xls format. >
Perhaps 'DAYS' will get you what you want. See the example in the help section. Also: Years, Months, Edate. You might find this helpful: <http://sc.openoffice.org/files/documents/11/2853/file_2853.dat/Validation%20of%20Calc%20Functions.pdf> --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
