Issue 123905

Summary:

DATEDIFF returns Error:508, and, the problem cannot be understood.

Product:

Calc

Reporter:

Jon C. <camilleri.jon>

Component:

editing

Assignee:

AOO issues mailing list <issues>

Status:

CLOSED DUPLICATE

QA Contact:

Severity:

Normal

Priority:

CC:

elish, issues, oooforum

Version:

4.0.1

Target Milestone:

---

Hardware:

All

OS:

All

Issue Type:

DEFECT

Latest Confirmation in:

---

Developer Difficulty:

---

Attachments:

Description	Flags
Attachment	none

Description Jon C. 2013-12-22 18:08:04 UTC

Created attachment 82148 [details]
Attachment

I am trying to calculate the number of days between two dates:
Cell 
A1: 12/22/1954 or 22/12/1954
A2: =TODAY()
A3: =datediff(B1,A1)

The cell A3 reads Error 508, however I cannot quite understand what is wrong with my input.

Error documentation at https://wiki.openoffice.org/wiki/Calc_Error_Codes, is vague.

Comment 1 Edwin Sharp 2013-12-22 19:36:28 UTC

Use same format for dates
Use function DAYS
Use semicolon

Comment 2 oooforum (fr) 2015-09-25 10:30:35 UTC

DATEDIF is not implemented at this time

*** This issue has been marked as a duplicate of issue 49467 ***