Stats >> WebLog >> Dates in Excel and R (August 10, 2005). Category: R software

Every program uses a slightly different method for calculating date values. Excel, for example, counts the number of days since the start of 1900 (January 1, 1900=1) for Windows, but for the Macintosh it uses 1904 instead of 1900.

If Excel encounters a two digit year, it places it in the 1900s if the two digits are 30-99 and places it in the 2000s if the two digits are 00-29. Time is a fractional portion of a day in Excel (0.25 equals 6am, 0.5 equals noon and 0.75 equals 6pm).

If you read date values into R, it will probably assume that the dates are strings. To convert from a string to a date format, use the command

date2 <- as.Date(date1, "%m/%d/%y")

R counts the number of days since the start of 1970 (January 1, 1970=0). It ignores fractional portions of the day. If you use two digit years, the results are specific to the system you are working on (just like Excel!). So the moral is to always type in and always display four digit years.

Stats >> WebLog >> Dates in Excel and R (August 10, 2005)

This page was last modified on 08/21/07. Send feedback to ssimon at cmh dot edu or click on the email link at the top of the page.

You are welcome to link to this page or other pages on this web site. Individual educational uses are also okay. Please contact me for permission to use these pages in any other way. For more details, please consult my copyright notice.