Formula Error

[jstevens]

I have a workbook that returns #REF! for the year function. The same cell formulas in a different sheet (same workbook) returns the same error. If entered into a new workbook the results are correct. It appears the workbook may be corrupt. My question is this recoverable without reinventing the wheel?

Code: Select all

Cell A1 formula =Today()           Result is '5/16/2021'
Cell A2 formula =Year(Today())     Result is #REF!  should be 2021

[HansV]

On the Formulas tab of the ribbon, click Name Manager.
Is there a defined name called Year?

[jstevens]

Hans,

I had a table named 'Year' in the Name Manager. After changing the table name the error message was resolved.

Thank you!