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?  

​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?    Read More

​