We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

DateTime from cell with formula is wrong

I have a pretty complex formula in Excel that calculates a date:


In Excel the value that's displayed is nothing, the formula calculates to null. But when I read the value in XlsIO it's converted to 31/12/1899. How is this possible? When I go to another row, the formula is parsed correctly. Any advise?

1 Reply

KK Konduru Keerthi Konduru Ravichandra Raju Syncfusion Team November 29, 2022 11:38 AM UTC

Hi Stephane,

As mentioned by you, the formula looks pretty complex. Requesting you to share the Excel document to investigate the query, as the formula has a large number of dependent cells. If you are not happy with sharing the file in public, please mail the file to support@syncfusion.com mentioning the forum ID.

We only use the customer files for testing and will not share or discuss them in any way.



Live Chat Icon For mobile
Up arrow icon