https://bugs.documentfoundation.org/show_bug.cgi?id=143947
--- Comment #2 from Henrik Palomäki <henrik.palom...@yandex.com> --- It seems a value in DATE function defaults to 0 if no number is given. It seems MS Excel acts in the same way. Should the default value be 1 instead of 0? In that case the expected result for the all given examples should be 2006-01-01. Currently, the value 0 in DATE function gives the previous value of 1 that is 12 for the case of month and in the case of day it is the last day of previous month. -- You are receiving this mail because: You are the assignee for the bug.