Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > microsoft.public.excel.programming > #108372

Re: Basic question about dates

From Claus Busch <claus_busch@t-online.de>
Newsgroups microsoft.public.excel.programming
Subject Re: Basic question about dates
Date 2015-12-22 09:58 +0100
Organization A noiseless patient Spider
Message-ID <n5b37l$ev$1@dont-email.me> (permalink)
References <kKadnY_MwPxF7O7LnZ2dnUVZ5sCdnZ2d@giganews.com> <XnsA573CAFCC37B7auricauricauricauric@213.239.209.88> <nYydnUouY58-kOTLnZ2dnUVZ5rOdnZ2d@giganews.com>

Show all headers | View raw

Hi Robert,

Am Tue, 22 Dec 2015 01:45:22 -0700 schrieb Robert Crandal:

> I assume that a long number is 32 bits?  That gives up to 4,294,967,295
> numbers.  I'm just curious, but what is the maximum date that can
> be represented by Excel?  Is it 12/31/9999?

integer numbers go from -32,768 to 32,767 
long numbers go -2,147,483,648 bis 2,147,483,647 

The greatest date is
12/31/9999 23:59 = 2958465.99930556


Regards
Claus B.
-- 
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Basic question about dates "Robert Crandal" <noreply2me@yahoo.com> - 2015-12-17 19:39 -0700
  Re: Basic question about dates "Auric__" <not.my.real@email.address> - 2015-12-18 02:54 +0000
    Re: Basic question about dates "Robert Crandal" <noreply2me@yahoo.com> - 2015-12-17 20:15 -0700
      Re: Basic question about dates GS <gs@v.invalid> - 2015-12-17 22:26 -0500
    Re: Basic question about dates "Robert Crandal" <noreply2me@yahoo.com> - 2015-12-22 01:45 -0700
      Re: Basic question about dates Claus Busch <claus_busch@t-online.de> - 2015-12-22 09:58 +0100
        Re: Basic question about dates "Robert Crandal" <noreply2me@yahoo.com> - 2015-12-22 02:26 -0700
          Re: Basic question about dates GS <gs@v.invalid> - 2015-12-22 10:49 -0500
  Re: Basic question about dates witek <witek7205@gazeta.pl.invalid> - 2015-12-17 21:23 -0600

csiph-web