| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum amount of days in another coloumn
Hi all,
I am using the below spread sheet Task Working days Start date End date 1 7 days 28/05/2010 07/06/2010 Analysis 1 2 days 28/05/2010 31/05/2010 Develop 2 1 wk 01/06/2010 07/06/2010 2 4 days 01/06/2010 04/06/2010 Analysis 1 1 day 01/06/2010 01/06/2010 Develop 2 3 days 02/06/2010 04/06/2010 3 7 days 02/06/2010 10/06/2010 Analysis 1 2 days 02/06/2010 03/06/2010 Develop 2 1 wk 04/06/2010 10/06/2010 I need to calculator the amount of working days based on if the days are for analysis or development. I would like to return the value in one cell for development and analysis work? Any one now how to do this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sort one coloumn according to another coloumn on another worksheet | Excel Worksheet Functions | |||
| Calculating unearned amount billed 45 days in advance... | New Users to Excel | |||
| Calculate Count of Days & Average WHERE Amount <0 | Excel Worksheet Functions | |||
| set a warning in excel after a certain amount of days | Excel Discussion (Misc queries) | |||
| amount of working days per month | Excel Discussion (Misc queries) | |||
Threaded Mode
