| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Networkdays with no start date and no end date
I want to be able to calculate how many working days there are between an
issue date and a completion date, but, if there is no completion date I want to know how many days have been worked to date, iknow how to do this part =networkdays(a1,if(b1="",today(),b1)) but, if there is no issue date (therefore no completion date) I want the formulae to return 0 days as there are jobs that come through but haven't been issued yet. at the moment the formulae returns a negative figure Is there anyone that can help me? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count between start date and end date | Excel Discussion (Misc queries) | |||
| Calculating Difference Between Start Date & Time And End Date & Ti | Excel Discussion (Misc queries) | |||
| how do I do a Planned vs Actual start date & end date graph | Charts and Charting in Excel | |||
| how do I do a Planned vs Actual start date & end date graph | Charts and Charting in Excel | |||
| Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions | |||
Threaded Mode
