Not sure but maybe

=IF(OR(C3=TODAY(),C4=""),0,C4-C3-1)

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



<FX wrote in message ...
maybe you can help solve this one..

=IF(TODAY()=C3,0,NOW()-C3-1)

the days open are counted based on a start date manually inputed in C3, a
closed date is manually inputed in a separate cell, for instance C4. I am
trying to craft my IF statement to stop counting days open based on the
closure date. Any suggestions?

Thx