If cell contains a date then link to another cell

[Danskylansky]

Hi All

I am trying to use an If statement to return a particular amount if a corresponding cell, on another table has a date (only - if it contains anything else i need it to be blank. Here are the tables:
Table 1:

Initials	Day 0	Day 7	Day 14	Delivery
	$500	$300	$800	$1500
M001	$500	$300
M002	$500			$1500

<tbody>
</tbody>

Table 2:

Initials	Day 0	Day 7	Day 14	Delivery
M001	01/01/2016	05/02/2016	08/03/2016
M002	03/01/2016	NA	NA	12/03/2016

<tbody>
</tbody>

I need the correct IF Statement to be applied on the first table: =if('table2'B2=date,'table1'B2,""). I realise that just using =date is not correct, but can't workout the correct function name to use
My problem is getting the if statement to only recognise if a date has been used in the corresponding cell.

Any help would be appreciated

Thanks

 

[AlanY]

try

=if(isnumber('table2'B2),'table1'B2,"")

 

[ww4612]

Function dat(ByVal r As Range) As Boolean
If r.NumberFormatLocal = "mm/dd/yyyy" Then
dat = True
Else
dat = False
End If
End Function

=if(dat('table2'B2),'table1'B2,"")

 

[Danskylansky]

Thank you AlanY! It worked!

 

[AlanY]

you're welcome