DATEVALUE Err:502 issue

[mbnoimi]

Hi,

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?

[JohnSUN]

Try just

=MONTH(A1)

Likely date does not need to convert using the DATEVALUE

[mbnoimi]

Thanks it works