IF Statement (Excel-2010)

Anyone know why this If statement isn't working?

=IF((('http://sharepoint/sites/00000/Testing/[Tested.xls]TEXT(Tested'!D3:D1000,"mm/dd/yyyy")=TODAY()), 'http://sharepoint/sites/00000/Testing/[Tested.xls]Tested'!B3:B1000)