Forum Discussion
Solved
Year Function returning #REF!; not sure why
I am actually a bit embarrassed for asking this, but I've been trying for 2 days now and cannot figure out why this is happening. I'm using the dynamic tables (but this problem happens in or ou...
- Maybe a named range called "year"?
Ben Kilman wrote:In the workbook that is correct, the formula is in caps- YEAR(A1); in the workbook where it is not working the formula wont stay in caps. When I hit enter, it changes to lowercase- year(A1).
Do you have a macro called "year"?
There are no macros in the workbook.
- Maybe a named range called "year"?
Thank you. That was it. I had a table named year.
I would not have thought to look for that.
Thank you, thank you, thank you...