Calc YIELD() function, Error 502

I’ve got a spreadsheet with 6 columns and near the bottom of each are formulas like this, which work fine in five columns:
=YIELD(J4,J5,J6,J7,J8,J9,J10)
But now, this formula is displaying Err:502:
=YIELD(K4,K5,K6,K7,K8,K9,K10)

I’ve re-checked the data types of the arguments. (The first two are dates [Default English USA] and the rest are numbers/general.) And I’ve fiddled with the dates just to see if anything changes.

I’ve re-set my user profile, installed the latest ver. 24.8.6.2(x86_64), and rebooted the machine (Windows 11 Professional).

I’ve just copied the last two columns (J & K) into Columns L & M with the same result. L is okay and M has the same error. I’ve also pasted all columns into a clean, new spreadsheet. No help. The last column has this error.

Can anyone suggest what is going wrong and how to fix it?

Many thanks.

1 Like

Nobody can tell without seeing the actual spreadsheet (not a screenshot).

Thanks so much for such a quick response. Spreadsheet attached.

yield to maturity study.ods (29.7 KB)

Avoid date formats with 2-digit years. The date in K6 is 1935-02-27.

1 Like

4 digits didn’t help, but I missed that 1935 tho I’ve noticed this problem before. Have to figure out how to prevent this in the future. THANKS x 1000.

EDIT: Obvious solution is to not use two digit years. Thanks again.