Forum Discussion
Built-in date format based on Datevalue
Dear members, I have noticed while working on date decoding that the excel returns incorrect date on datevalue (one day less). For example the data given in follwing table calculates day as 5th o...
Hi,
Perhaps you took incorrect starting point in your calculation. Zero is Jan 00, 1900 (1900-00-00 00:00) and when the previous century starts on Jan 01, 1900 (1900-01-01 00:00:00) that's 1.