Ask Your Question

DAYS Function Being Replaced with "_xlfn." in Excel

asked 2016-01-15 15:00:49 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

I'm working on a document in LibreOffice, but it's saved in XLS format so it can be shared with co-workers using Excel. I use the DAYS function extensively, but when my co-workers open the file in Excel the characters "_xlfn." have been appended to DAYS (making it '_xlfn.DAYS') and the formula breaks.

Is there a solution?


edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2016-01-19 16:15:16 +0200

erAck gravatar image

Excel does not know the DAYS() function, hence you get the raw _xlfn.DAYS() there and calculations using it don't work. The good news is that you don't need the DAYS() function, simply subtracting two dates gives the same result, in both Calc and Excel.

edit flag offensive delete link more

answered 2016-01-15 20:29:55 +0200

horst gravatar image

Save your Excel file as .ODS (LO native format), work only in the .ODS format. Once finished save it in ODS and in .XLS for giving it away. That should work.

edit flag offensive delete link more


It does not help for the problem that Excel doesn't know the DAYS() function.

erAck gravatar imageerAck ( 2016-01-19 16:16:03 +0200 )edit

Excel 2013 knows the DAYS function. 2010 does not even it is defined in the OASIS documentation.

horst gravatar imagehorst ( 2016-01-22 17:41:19 +0200 )edit

Ok, then another correct answer would be "make your co-workers use Excel 2013, or even better make them use LibreOffice" ;-P

erAck gravatar imageerAck ( 2016-01-22 17:44:10 +0200 )edit

@erAck you got it!!

horst gravatar imagehorst ( 2016-01-22 20:30:52 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-01-15 15:00:49 +0200

Seen: 13,971 times

Last updated: Jan 19 '16