A detailed description of the Excel problem as seen through the eyes of
MS can be found at
http://support.microsoft.com/kb/214326
On 3/2/2011 8:15 AM, Prof Brian Ripley wrote:
## Excel is said to use 1900-01-01 as day 1 (Windows default) or
## 1904-01-01 as day 0 (Mac default), but
On Wed, 2 Mar 2011, Erich Neuwirth wrote:
A detailed description of the Excel problem as seen through the eyes of
MS can be found at
http://support.microsoft.com/kb/214326
No, that's only half the problem. The description at
http://support.microsoft.com/kb/214330
(as cited in the
Hello. I am using some dates I read in excel in R. I know the excel origin
is supposed to be 1900-1-1. But when I used as.Date with origin=1900-1-1 the
dates that R reported me where two days ahead than the ones I read from
Excel. I noticed that when I did in R the following:
-Original Message-
From: r-help-boun...@r-project.org [mailto:r-help-bounces@r-
project.org] On Behalf Of Luis Felipe Parra
Sent: Tuesday, March 01, 2011 3:07 PM
To: r-help
Subject: [R] Difference in numeric Dates between Excel and R
Hello. I am using some dates I read in excel
On 2/03/2011 12:31 p.m., Nordlund, Dan (DSHS/RDA) wrote:
-Original Message- From: r-help-boun...@r-project.org
[mailto:r-help-bounces@r- project.org] On Behalf Of Luis Felipe
Parra Sent: Tuesday, March 01, 2011 3:07 PM To: r-help Subject: [R]
Difference in numeric Dates between Excel
On Wed, 2 Mar 2011, Luis Felipe Parra wrote:
Hello. I am using some dates I read in excel in R. I know the excel origin
is supposed to be 1900-1-1. But when I used as.Date with origin=1900-1-1 the
dates that R reported me where two days ahead than the ones I read from
Excel. I noticed that when
6 matches
Mail list logo