Formula Error

jstevens
SilverLounger
Posts: 2418
Joined: 26 Jan 2010, 16:31
Location: Southern California

Formula Error

Post by 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
Regards,
John

User avatar
HansV
Administrator
Posts: 71516
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Formula Error

Post by HansV »

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

jstevens
SilverLounger
Posts: 2418
Joined: 26 Jan 2010, 16:31
Location: Southern California

Re: Formula Error

Post by jstevens »

Hans,

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

Thank you!
Regards,
John