Hi Ron
Thank you for your reply and effort the formula works great
You are a gentle man !

regards bill
--
bill gras


"Ron Rosenfeld" wrote:

On Fri, 28 Oct 2005 09:46:53 -0400, Ron Rosenfeld
wrote:

On Fri, 28 Oct 2005 05:21:08 -0700, bill gras
wrote:

Hi Ron
Your formula only returns Datedif between Today()-T44 and does not
return the difference between T44-T45 if AG44 is blank

bill
--
bill gras


In addition to my previous post, your specification had to do with AG44 being
blank. A blank cell has nothing in it. It is EMPTY. If AG44 has something in
it, then it is NOT BLANK. (see HELP for the ISBLANK worksheet function)

For example, if AG44 has a formula in it, then it has a formula in it.
Containing a formula that returns a null string is NOT the same as a BLANK
cell.

If that is the case, you need to change the logical_test to account for the
actual conditions.

If, for example, you have a formula in the cell that is returning a null
string, e.g. "", then the difference formula needs to take that into account:

So, what exactly is in AG44 ???
--ron

Finally, I reread your specification. And, indeed, you do have a formula in
there.

My post was actually just in reference to Paul's formula and I had not looked
at the source posting closely, being distracted by the use of BLANK.

My apologies.

Modifying that formula, and assuming that the formula in AG44 returns a null
string ("") (not a blank), then:

=IF(AG44="",T44-T45,IF(AG441,TODAY()-T44,""))





--ron