108127 – DATEDIF doesn't work

Bug 108127 - DATEDIF doesn't work

Summary: DATEDIF doesn't work

Status:	RESOLVED NOTABUG

Alias:	None

Product:	LibreOffice
Classification:	Unclassified
Component:	Calc (show other bugs)
Version: (earliest affected)	5.3.3.2 release
Hardware:	x86-64 (AMD64) macOS (All)

Importance:	medium normal
Assignee:	Not Assigned

URL:
Whiteboard:
Keywords:

Depends on:
Blocks:

Reported:	2017-05-26 14:22 UTC by Peter Fackelmann
Modified:	2017-05-26 15:19 UTC (History)
CC List:	2 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.

Description Peter Fackelmann 2017-05-26 14:22:36 UTC

The function

=datedif(E5;F5;m)

doesn't work in LibreOffice.
It works in Apple Numbers.

What do you propose?

Comment 1 Xisco Faulí 2017-05-26 15:04:04 UTC Comment hidden (obsolete)

Hello Peter,

Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. 
I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided.
(Please note that the attachment will be public, remove any sensitive information before attaching it. 
See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.)

Comment 2 Jacques Guilleron 2017-05-26 15:17:41 UTC

Hi Peter,

Write rather: =DATEDIF(E5;F5;"m")

Jacques