I want to convert date in the format "dd.mm.yyyy" into serial.
Column B includes dates in the format "dd.mm.yyyy" I write a formula which is "=DATEVALUE(B2)" in a cell on column C. I get "#VALUE" error.
How to do that?
I want to convert date in the format "dd.mm.yyyy" into serial.
Column B includes dates in the format "dd.mm.yyyy" I write a formula which is "=DATEVALUE(B2)" in a cell on column C. I get "#VALUE" error.
How to do that?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks