Complex formula help

[DQ-JN]

I have attached a simplified version of my massive spread sheet. Since it is confidential i have changed things but the point is the same. Any help ASAP is very much appreciated. I spent 2 hrs trying to figure this out.

Look at the spread sheet

Ok so after viewing it if cell B and C are not filled out with a date yet i need them to be a zero so that I still have the number of days running in cell F, thing is these cell b and c really need to remain blank until the date gets filled out. Currently they show a time from like Jan 1 1900 per excell default since no date is present hence the 41136 days. I have to do statistics on cell D and E so if i do not have dates for B and C then really D and E need to show 0 so they don't screw up the numbers. Please help.

Thanks a million if you can help. I am using Excel 2007 but use Excel 2010 at work. Also any macro for this would be very much appreciated."

link to the pic of the document is dq-jn excel help.xlsx - DocDroid

 

[cstimart]

Would this solve your problem in Cell D3?

=IF(OR(B3=0,C3=0),0,IF(B3>1,C3-B3,C3-TODAY()))

And this in E3?

=IF(C3=0,0,A3-C3)

 

[Robert Mika]

=if(or(b3=0,c3=0,b3>1),0,c3-b3)

 

[cstimart]

=if(or(b3=0,c3=0,b3>1),0,c3-b3)

shouldn't B3 be >1?