| 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 |
| 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) | |||
Threaded Mode
