I have a pretty complex formula in Excel that calculates a date:
=IF(AND($AP$6>BL19;$AP$6<BL19+(BM19*30,5));BL19+(BM19*30,5)+$AS$6;IF(AND($AQ$6>BL19;$AQ$6<BL19+(BM19*30,5));BL19+(BM19*30,5)+$AQ$6-BL19;IF(AND($AP$7>BL19;$AP$7<BL19+(BM19*30,5));BL19+(BM19*30,5)+$AS$7;IF(AND($AQ$7>BL19;$AQ$7<BL19+(BM19*30,5));BL19+(BM19*30,5)+$AQ$7-BL19;IF(AND($AP$8>BL19;$AP$8<BL19+(BM19*30,5));BL19+(BM19*30,5)+$AS$8;IF(AND($AQ$8>BL19;$AQ$8<BL19+(BM19*30,5));BL19+(BM19*30,5)+$AQ$8-BL19;IF(AND($AP$9>BL19;$AP$9<BL19+(BM19*30,5));BL19+(BM19*30,5)+$AS$9;IF(AND($AQ$9>BL19;$AQ$9<BL19+(BM19*30,5));BL19+(BM19*30,5)+$AQ$9-BL19;IF(AND($AP$10>BL19;$AP$10<BL19+(BM19*30,5));BL19+(BM19*30,5)+$AS$10;IF(AND($AQ$10>BL19;$AQ$10<BL19+(BM19*30,5));BL19+(BM19*30,5)+$AQ$10-BL19;BL19+(BM19*30,5)))))))))))
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?
