Issue 49467

Summary: function datedif() is missing
Product: Calc Reporter: richpainter <painter>
Component: programmingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: camilleri.jon, issues, kamataki, pescetti, srt2006, tora3, vulcain, y-catch
Version: OOo 1.1.4   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: FEATURE Latest Confirmation in: ---
Developer Difficulty: ---

Description richpainter 2005-05-18 18:19:35 UTC
The function datedif() is missing.  This function has been used in Excel since
version 5 and is extremely useful.  I use Excel spreadsheets that are protected
that use datedif() so I need this function to work as is in order to switch over
to using OpenOffice.  This link
documents this function as found in Excel.  I realize that this complaint was
raised over 2 years ago but since it is in common use with Excel OpenOffice
should support it because many times there is no way to change the existing
spreadsheet to make a work around (this is my situation).  Also, if it is so
"simple to implement" then just add the needed code to properly implement
datedif() in OpenOffice.  Otherwise this will be just another reason for people
to NOT migrate to OpenOffice.
Comment 1 frank 2005-06-13 11:21:55 UTC
one for the requirements team
Comment 2 Andrea Pescetti 2012-10-02 21:33:56 UTC
As Dennis Hamilton noted on ooo-users , DATEDIF() is part of OpenFormula (part 2 of the ODF 1.2 Specification). So it's already formally specified and standardized. This is an important prerequisite to check before starting the implementation.
Comment 3 vulcain 2013-01-28 09:51:38 UTC
Resolved in LibreOffice 3.6:
Comment 4 oooforum (fr) 2015-09-25 10:30:35 UTC
*** Issue 123905 has been marked as a duplicate of this issue. ***