YEARFRAC doesn't work with structured reference in excel table

[jaxhax]

Using Excel 2016.

Create an excel table with 3 columns:
date1
date2
year_frac

Add one row to the table. In the date columns, put any dates
Format the table using the "Format as Table" feature.

in the year_frac column enter this formula:
=YEARFRAC([date1],[date2])

The formula appears to work fine with only one row in the table.
Add another row to the table, then the formula returns #VALUE ! error.

Use "Show Calculation Steps" and it appears that the structured reference points to the entire column range, not just the cell in that row.

If I change the formula to:
=YEARFRAC([A2],[B2])

It works fine. The structured reference in the YEARFRAC formula seems to make it not work.
Am I missing something?
Thanks, Jack

 

[Tetra201]

Try

=YEARFRAC([@Date1],[@Date2])

 

[jaxhax]

Yep, that works. I guess I just didn't really understand well enough how structured refs worked.
Thank you!