DATEVALUE Err:502 issue


I want to parse date cell for getting the used month (ex. ‘2014-04-22’ the result should be ‘04’); For that I used DATEVALUE function but I always get Err:502!!!

How can I fix this issue?

Try just


Likely date does not need to convert using the DATEVALUE

Thanks it works