I have a similar problem with the DAYS() function. =DAYS(NOW(), "10/10/2009") gives #VALUE! but putting 10/10/2009 into cell B3 and doing =DAYS(Now(), B3) seems to work OK.
I also have Openoffice 3.1 running under Xubuntu 9.1 and this works as expected. -- Date strings not interpreted as dates by the YEARS function https://bugs.launchpad.net/bugs/569532 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
