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?