if E3 is null, then "", else =E3-TODAY() Check out our Excel Resources Re: Null values Posted by Barrie D ...
www.mrexcel.com