Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Dates
if(b1<now(),networkdays(a1,b1),0)
would seem to be the easiest fix |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Dates
except of course it should have been b1now() as we want the
calculation to happen if B1 is a future date - sorry about that!!! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Dates
Try this:
=MAX(0,NETWORKDAYS(A1,B1)) Does that help? *********** Regards, Ron XL2002, WinXP "Leon" wrote: 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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Dates
Thanks to the both of you thats exactly what i needed.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
unhide menu bar in excel - just disappeared | Setting up and Configuration of Excel | |||
Can you export dates in Excel to a calendar? | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Ensure dates imported into Excel 2003 are shown in DD/MM/YYY form. | Excel Discussion (Misc queries) |