date or text

R

rexmann

Hi

Is there a way of working out if the information in a list is text or a date.

In a long list I need to determine the above.

It needs an IF statement so if it is a date perform a calculation otherwise do not.

can anyone help. Any suggestions are appreciated

kind regards

Rexmann
 
J

JulieD

Hi Rexmann

there is an ISTEXT function which returns true if the entry is text and
false if its not so you could construct an IF statement along the lines of:

=IF(ISTEXT(A1),"text","not text")

Cheers
JulieD
 
F

Freemini

another way which differentiates between numbers, text and dates

=IF(LEFT(CELL("format",C6))="D","Date","")

hth

Mik
 
D

Dave Peterson

You might want to add a check to see if there's a date in that cell--not just
check the format:

=IF(AND(ISNUMBER(C6),LEFT(CELL("format",C6))="D"),"Date","")
 
Top