Hi Bill

I think there was a typo in Arvi's formula and it should read
=IF(AND(AG44<"",AG44<=1),"",DATEDIF(T44,IF(AG44=" ",T45,TODAY())))

Regards

Roger Govier


bill gras wrote:
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