Excel 2007 IF function

Hello,

Need formula to say if cell has NA put 0 but if the cell has a date (yy,mm,dd) then subtract cell L1 from cell E1. Trying to determine how many days from date form received until date auth put in.

I have formulas to make each function happen separately but can't put it all together so far.


=IF(L11="NA","0")

=IF(L16=DATE(2012,6,3),"",L16-E16)

Thanks in advance
Nikki