Page 1 of 1

Excel serial dates conversion in GP

Posted: Jul 17th, '19, 06:30
by manyone
i'm attaching functions for converting Excel serial dates to YMD dates and back. Excel serial dates represents the number of days since 12/31/1899 . Excel has a bug - it treats 1900-2-29 as a leap date when in fact it's invalid, since 1900 is not a leap year. These 2 functions replicate the same behavior, for consistency. Actually, i translated the code that can be found in this article. you can read all about it here:
https://www.codeproject.com/Articles/27 ... Vice-Versa
serial dates.JPG
serial_dates.gpp
(7.17 KiB) Downloaded 874 times