Excel 2007 IF function

Nikki - Jun 25, 2012 at 09:35 AM
 Nikki - Jun 25, 2012 at 10:41 AM

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.



Thanks in advance

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Jun 25, 2012 at 09:52 AM
Hi Nikki,

Your story contradicts your formula's a little so I will just look at the formula's and merge them:


Best regards,
Thank you very much. I see what I was doing wrong.