MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Another IF(ISBLANK Question

Posted by Dee on February 05, 2002 10:10 AM

I posted part of this earlier, but now have another question.
If I have the day I sent something out in D6, the Day (If applicable)that it is returned in E6, the # of days it's been out in F6 (With this formula: =IF(ISBLANK(D6),"",DATEDIF(D6,NOW(),"d")) and the total days out once it's been returned if G6. My question is this, Once I get something back I want the days out column to automatically be empty and the days it took to have the figure in it. Is this possible?

Posted by Bariloche on February 06, 2002 7:39 PM


This should be what you're looking for:

in cell F6, put: =IF(ISBLANK(D6),"",IF(ISBLANK(E6),DATEDIF(D6,NOW(),"d"),""))

in cell G6, put: =IF(ISBLANK(E6),"",DATEDIF(D6,E6,"d"))

have fun