<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED WONTFIX - Day function for creating date is off by one"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=124231#c4">Comment # 4</a>
on <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED WONTFIX - Day function for creating date is off by one"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=124231">bug 124231</a>
from <span class="vcard"><a class="email" href="mailto:erack@redhat.com" title="Eike Rathke <erack@redhat.com>"> <span class="fn">Eike Rathke</span></a>
</span></b>
<pre>To add to this, DAY(21) is not only unnecessary, it's wrong. DAY() calculates
the day of month of the date serial number (days since null date) passed as
argument. The date serial number 21 here happens to represent 1900-01-21 in
Excel so there's no visible difference in the result, but 1900-01-20 in Calc
because of Excel's leap year bug for which Calc shifts the null date.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>