DATEVALUE function

Welsh Mark3

Board Regular
Joined
Apr 7, 2014
Messages
86
I have a column of data which I thought were dates but the data doesn't seem to behave as such.
I have attempted to use Datavalue function but no am getting #value !

I believe I have checked my system date and time settings, Doesn't anyone have any advice?
 

JoeMo

MrExcel MVP
Joined
May 26, 2009
Messages
16,691
Can you post some examples of your "dates" so we can see the format. If you have a "date" in cell A1, what does =ISNUMBER(A1) return when entered in any empty cell?
 

Forum statistics

Threads
1,086,227
Messages
5,388,568
Members
402,125
Latest member
mtwood83

Some videos you may like

This Week's Hot Topics

Top