I want to use YEARFRAC For my calculation
Eg:
in cell A3 i have given date 10/10/2010
in cell A4 i have given date 10/10/2020
in A5 i have given formula =YEARFRAC($A$3,$A$4,1)
When i evaluate formula using Formula Evaluator in
java its throwing exception as
java.lang.RuntimeException: Not implemented yet
at org.apache.poi.xssf.usermodel.XSSFEvaluationWorkbook.getNameXPtg(XSSFEvaluationWorkbook.java:105)
at org.apache.poi.ss.formula.FormulaParser.function(FormulaParser.java:916)
at org.apache.poi.ss.formula.FormulaParser.parseNonRange(FormulaParser.java:556)
at org.apache.poi.ss.formula.FormulaParser.parseRangeable(FormulaParser.java:427)
at org.apache.poi.ss.formula.FormulaParser.parseRangeExpression(FormulaParser.java:266)
Can any one help me to resolve this issue? It is too urgent.
Thanks in advance.