MONTH function returning #REF error

Hi,

In one of my files, the MONTH function is returning a #REF error.
I've even tried simplifying it to '=MONTH(A1)' -- with A1 just being 1/1/2016 and still get the #REF
(when I try it in a new workbook, i get the correct result (1), leading me to believe it's an issue w/ my original file

Has anyone experienced this?

Would be great if you could assist

Thanks!

Originally Posted by Tony Valko

You'll get the #REF! error if you ever delete rows/columns that a formula references.

Maybe this...

=MONTH(INDIRECT("A1"))

That formula will ALWAYS refer to cell A1.

no, that doesn't seem to be the issue (nothing ha been deleted, and the indirect didn't help)
this is weird, i consider myself pretty well versed at excel, but i've never experienced this before

Originally Posted by Tony Valko

You'll get the #REF! error if you ever delete rows/columns that a formula references.

Maybe this...

=MONTH(INDIRECT("A1"))

That formula will ALWAYS refer to cell A1.

FOUND IT!
I had a table w/ the name "MONTH" so when i was putting in the month function, Excel was assuming i was refering to the table, and since that syntax wouldn't make sense, i was getting an error
Once I changed the name of the table to MONTH_TBL the issue was resolved