Excel number convert to date format?

[DannyJ]

The Excel funtion (_XLSXReadToArray) reads the date like a number: 44225

The Excel starts counting the days from 1900.01.01 and the funtion reads the date format from Excel like a number.

How to convert this number to an actual date

Like

Convert(44225)

The result is the proper date from this numeric string or integer

2021.01.29 or 01/29/2021

 

 

[water]

I think the mentioned function should do this automatically by calling function _SSNToDate. Just have a look at the source code.
If it doesn't then you could call the function yourself.