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

It's not my formula, but I don't understand what you are saying.

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

Did you actually try it? If AG44 is blank, it will return a zero which, in my
world, is less than 1. Therefore the logical_test evaluates to FALSE, and the
value_if_false will be returned.

Here are some sample runs:

T44: 15 Feb 2005
T45: 19 Feb 2005

AG44: <blank -- -4 (difference between T44-T45)
AG44: 2 -- 255 (difference between T44 and TODAY())


--ron