Excel Dates

[Leon]

Hi Im using the networkdays function to calculate the days remining until an
expiry
date. but when the expiry date is pasted the days remaining goes into minus
figures. Is there any way to stop this so the days remaining stay at zero.
eg.

=NETWORKDAYS(A1,B1)

A1 B1 C1
Todays date Expiry date days remaining
17/05/06 14/04/06 -24

 

[aidan.heritage]

if(b1<now(),networkdays(a1,b1),0)

would seem to be the easiest fix

 

[aidan.heritage]

except of course it should have been b1>now() as we want the
calculation to happen if B1 is a future date - sorry about that!!!

 

[Ron Coderre]

Try this:

=MAX(0,NETWORKDAYS(A1,B1))

Does that help?
***********
Regards,
Ron

XL2002, WinXP

 

[Leon]

Thanks to the both of you thats exactly what i needed.