Logic for DateTimeValue

When reading in a numeric field from an .XLSB file, I’m seeing that the value 32.38 is giving me the DateTime value of 2/1/1900 9:07:12 AM when inspecting the DateTimeValue property of the Cell. Can you enlighten me on how this value was reached?

@astera,
Please have a look at the following article which explains conversion of number to date in Excel.

Which part of this article should I be looking at? When I try to use the DATEVALUE function in Excel directly, I get an error of “a value used in the forumula is of the wrong data type”, which makes sense. But, this is not what happens when I use the DateTimeValue.

Nevermind, I see that it is a combination of Date and Time formatting for the cell.

@astera,
It seems that your issue is resolved. Feel free to write us back if you have any other query in this regard.