Archive of Mr Excel Message Board
Back to Forms in Excel VBA archive index
Back to archive home
Another IF(ISBLANK QuestionPosted 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 QuestionPosted 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"))
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
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.