Archive of Mr Excel Message Board

Back to Forms in Excel VBA archive index
Back to archive home

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?

Check out our Excel Resources

Re: Another IF(ISBLANK Question

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

This archive is from the original message board at
All contents © 1998-2004
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.