"DaveW" <dave@[EMAIL PROTECTED]
> wrote in message
news:39e778d1-a78a-42db-8fd4-ab020480b218@[EMAIL PROTECTED]
Apr 23, 2:29 am, AAsk <AA2e...@[EMAIL PROTECTED]
> wrote:
>...
> Earlier you mentioned 01/03/1900. The default base date in Excel
> (1900) failed to recognise 1900 as a leap year. However, you do have
> the option of switching the base date to 1904.
I did not see the original reference, but it should be pointed out
that 1900 was not a leap year (as opposed to 2000, 2400, etc.).
Dave
thanks Dave.
But besides that, for the industries I mentioned you can't just
"switch the base", that would be unjustified patchwork - a day
more or less, who cares?
insurance companies, pensionfunds, bankers, tax-collectors, notaries
and what have you are counting in days, and a few of 'em over three
centuries;
so, switch the base is not an option
MultiPlan, VisiCalc, MS Excel - they all copied and pasted the
1900-leapyear-day - one after another, that is ...
bad conduct IMV
|
