Excel serial dates conversion in GP
Posted: Jul 17th, '19, 06:30
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
https://www.codeproject.com/Articles/27 ... Vice-Versa