Nested IF Statement

[Bill]

Greetings,
Can I test a cell to see if it is Numeric or a date, and
if true find the day difference between?
I am using Excel 2000 and have attemepted the following

=IF(B2=numeric and D2=numeric,IF(B2<D2,days360,0),0)
Only excel tells me it doesn,t recognise a word?, ie
returns #name.

I am testing an existing workbook. There is a mixture of
alpha (Sent, delayed , TBA) and date information in a
cell, but only one type at a time.
I want to find the day difference between to ajacent cells
but filter out the alpha to stop getting a #value return
if I only use days360.

cheers
regards
Bill

 

[Frank Kabel]

Hi
try
=IF(AND(ISNUMBER(B2),ISNUMBER(D2)),MAX(D2-B2,0),0)
and format this cell as number

 

[Bill]

Cheers,
Works Fantastic.
Very Much Appreciated.
Warm regards.

 

[Harlan Grove]

...
...

=IF(AND(ISNUMBER(B2),ISNUMBER(D2)),MAX(D2-B2,0),0)

...

Or

=IF(COUNT(B2,D2)=2,MAX(D2-B2,0),0)