Excel Dates
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
|