Hi Arvi
Thank you for your imput
Your formula does not work for me , it tels me that a ) or a , is missing
so I tried to adjust it but all I get is a #num! error

bill
--
bill gras


"Arvi Laanemets" wrote:

Hi


=IF(AND(AG44<"",AG44<=1),"",DATEDIF(T44,IF(AG44=" ",T45,TODAY())


--
Arvi Laanemets
( My real mail address: arvil<attarkon.ee )



"bill gras" wrote in message
...
Hi All
I need a date difference with a certain condition :
If AG44 is greater than 1 give me the date difference between T44 and
TODAY(),
if AG44 is blank (has a formula that returns a blank cell) than give me
the
date
difference between T44 and T45 and that needs to be coppied down to 3000
rows

can some one please help
regards bill
--
bill gras