#VALUE! when I use Month fuction

Copper Contributor

I downloaded a file from the Sales force report for my company and tried to use MONTH fuction for the cell which has 10/13/2024, but I was faced with #VALUE! return value. However, one of my co-worker tried the fuction with the exact same file and same cell, and the result was success. Even the excel version is the same '2019 MSO (16.0,10410.20026) 64 bit. Can I know the reason?  

1 Reply


It depends on regional settings on your computers. For US locale 10/13/2024 is recognized as date and MONTH() works, For other locales it recognizes as text and MONTH() returns an error.

If above dates are in the column you may convert them into the dates with Date->Text to Columns with type Date and MDY on third step.