Ask Your Question
0

DATEVALUE Err:502 issue [closed]

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

mbnoimi gravatar image

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

Alex Kemp gravatar image

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?

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
1

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

JohnSUN gravatar image

Try just

=MONTH(A1)

Likely date does not need to convert using the DATEVALUE

edit flag offensive delete link more

Comments

Thanks it works

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

Question Tools

1 follower

Stats

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

Seen: 861 times

Last updated: Apr 24 '14