Bug 103904 - DATUMDIF result not number but date
Summary: DATUMDIF result not number but date
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.1.6.2 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-11-13 13:12 UTC by Thomas Bartel
Modified: 2016-11-14 19:51 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Screenshot of DATUMDIF error (30.86 KB, image/jpeg)
2016-11-13 13:12 UTC, Thomas Bartel 		Details
View All 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 Thomas Bartel 2016-11-13 13:12:09 UTC 
Created attachment 128720 [details]
Screenshot of DATUMDIF error

Function DATUMDIF result should be a number (days between first and second date) but is a date.
See screenshot.
Comment 1 MM 2016-11-13 19:41:20 UTC 
You might wanna try DATEDIF instead.

https://help.libreoffice.org/Calc/DATEDIF
Comment 2 Aron Budea 2016-11-14 05:59:53 UTC 
MM, DATUMDIF is the German localized name for DATEDIF.

Thomas, can you check if you right click the cell with DATUMDIF, and select Format Cells..., which Category is selected? If it's Date, change to Number.

I tried with an empty spreadsheet, and if I added the formula to an empty cell, it displayed the number correctly, but if previously Date was selected in the column, then it would display the formula result as date (it's only a display issue, changing Category to Number is a manual fix).
Comment 3 Thomas Bartel 2016-11-14 09:31:27 UTC 
Aron Budea, you are right, it was Date formatted. I switched it to Numbers, now it's ok.
Thanks!
Comment 4 Aron Budea 2016-11-14 19:51:21 UTC 
All right, that seems fine, then. Probably cell format was changed to date at some point before, that's why it was displayed as one. Closing as NOTABUG.