https://bugs.documentfoundation.org/show_bug.cgi?id=161591
--- Comment #6 from ady <[email protected]> --- Maybe I was not clear/specific enough. I am able to obtain the correct result using the date format mentioned in comment 0. This is the reason I posted instructions in comment 1. The way I tested it was: 1. Format cells A2:B2 as YYYY-MM-DD 2. Introduce the dates: 2.1. A2: 2020-01-12 2.2. B2: 2020-06-20 3. C2: =12*YEARFRAC(A2;B2) 4. Format cells A2:B2 as DD MMM, YYYY There might or might not be some problem when introducing the dates, but the function is correctly showing the expected result, and the cells show the expected date format. Please review your steps (and the instructions). Please clarify whether there is some discrepancy. Otherwise, someone else needs to attempt to reproduce the problem, or this is more a question for <https://ask.libreoffice.org> rather than a bug report. -- You are receiving this mail because: You are the assignee for the bug.
