CODEWITHSUNDEEP
exceldateexcel-formulabloomberg
Nikolajs
Nikolajs

Reputation: 335

DATEVALUE issue in Excel

I'm trying to run a simple excel function to compare two dates, however for some reason I get a #VALUE error when using DATEVALUE.

The weird thing is, I do not get this error when I use DATEVALUE for one cell, but I do get it for all other cells.

I'm not getting this issue for the below.

CELL M:42   -   extracting a date from Bloomberg with function =BDP

CELL L:42   -   =DATEVALUE(M:42)  - gives me datevalue

I get the issue when trying to use =DATEVALUE from any other cell.

CELL M:41   -   11/29/2019
CELL L:41   -   =DATEVALUE(M:41)  - gives me #VALUE error

Upvotes: 0

Views: 966

Answers (1)

Nikolajs
Nikolajs

Reputation: 335

Thank you all for the help.

I fixed this by taking the date from Cell M:41 and making it a string value.

Upvotes: 0

Related Questions