Ask Your Question

DATEVALUE Err:502 issue [closed]

asked 2014-04-24 12:43:14 +0200

mbnoimi gravatar image

updated 2015-09-07 22:14:54 +0200

Alex Kemp gravatar image


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?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-21 07:15:01.364136

1 Answer

Sort by » oldest newest most voted

answered 2014-04-24 14:29:57 +0200

JohnSUN gravatar image

Try just


Likely date does not need to convert using the DATEVALUE

edit flag offensive delete link more


Thanks it works

mbnoimi gravatar imagembnoimi ( 2014-04-24 16:09:31 +0200 )edit

Question Tools

1 follower


Asked: 2014-04-24 12:43:14 +0200

Seen: 1,051 times

Last updated: Apr 24 '14