How about
=IF(NETWORKDAYS(B3,C1)<0,0,NETWORKDAYS(B3,C1))
D-C
Sherry wrote:
I have a cell that calculates how many business days between two dates
=NETWORKDAYS(B3,C1).
If that formula produces a negative number I would like the value of the
cell to be 0 "zero".
Any suggestions?
----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----