Re: COUPNCD COUPPCD Aarrrghhhh!

[Nick Lamb <njl98r ecs soton ac uk>]

On Thu, Jan 17, 2002 at 09:14:51PM -0000, Morten Welinder wrote:
> I wish people would use 4-digit years in these tests (as well as months
> with letters) in order to avoid any extra trouble which may result from
> differences in locales and possibly in century guessing.

All up-to-date Microsoft info states that you should always use DATE(y,m,d)
to construct dates in Excel properly. It avoids most problems, even the
1904 issues. It also requires 4 digit years.

So basically I think Gnumeric test cases should use DATE() as much as
possible.

Nick.