Int DMYToExcelSerialDate( int nDay, int nMonth, int nYear) 1900 is not a // leap year, but Excel/Lotus 123 think it is.
Void ExcelSerialDateToDMY( int nSerialDate, int &nDay,
#Lennox serial number date code code
And when the 29-02-1900 issue is handled, we've got an Excel serial date to Day, Month, Year calculation!Ĭopy Code // date_test.cpp : Defines the entry point for the console application. With an addition of a certain number, the algorithm comes close to the Excel serial date. I won't bore you with the theory (following the above hyperlink), but the original Julian has a different base date. It's about converting a Julian date to DMY using integer calculations. Translating Serial Date Number to DMYįirst of all, credit where credit is due. That's why Excel also features a "1904 Date System" checkbox in its Options (Calculation tab).
#Lennox serial number date code mac
It's actually the percentage of 24 hours, but that's not for this article.) Mac Excel Serial Date numberĮxcel on the Apple Mac uses a slightly different Serial Date number base: the number of days since 1-1-1904. (Note that a serial date number may also contain a fraction that denotes the time. This allowed Excel to open Lotus 123 spreadsheets without date problems. Microsoft Excel however contains a bug with its date calculation: it considers 29-02-1900 as a valid date, but 1900 isn't a leap year! 29-02-1900 is not a valid date!Īccording to the stories, Microsoft decided to duplicate this date bug from Lotus 123, which was the dominating spreadsheet application at the time Excel was being written. The number of days since 1-1-1900 isn't that hard to calculate of course, once you know the leap years. 37477 actually translates to Aug 9, 2002, the date of writing this article. Now what is an Excel serial date number? 37477 is a serial date number and is the number of days since 1-1-1900. After some Googling, I learned that the Excel serial date is related to Julian date, and found a speedy algorithm to convert these numbers to DMY and vice versa. The serial number came from date field in a converted Paradox database and seemed to be exactly the same as the serial date in Microsoft Excel, hence the article name. For a little project of mine, I needed to convert a serial date number to day/month/year (DMY) and vice versa.
0 kommentar(er)
