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"?
Can you upload your workbook? Would help to be able to see the formatting of your cell. Thanks. EDIT: FYI, caps does not matter for your formula. You can write it in all lower-case or proper-case and it'll work perfectly fine. Test it yourself.
- Yes I can, let me remove personal info first and then I will add it.
It will be Tab: Misc Purchases that shows both the issue and the year that is working but with the error msg.
