Forum Discussion
Irregular date calculations in large spreadsheet
I've been managing finances for a long time now in Excel. It has grown to 11.500 lines over a period of 20 years en recently my date calculations start to give #VALUE outcomes.
The formula in line 11498 is "=ALS(H11498<>"";H11498+7;D11498+14)"
The field H11498 contains a date (25-6-2025) and has cell characters of a date.
Similar formula in 11497 works like a charm.
11498, 11499 and 11500 give #VALUE
11501 works like a charm again.
Any ideas? Have I run out of Excels possibilities in regards to the size of the spreadsheet?
3 Replies
Either H11498 or D11498 is text. Check with ISTEXT().
Doublechecked but both fields are dates...
The output of ISTEXT() is either TRUE or FALSE not "dates".
